Sql statement FIND the book code and book title for each book whose price is greater than the book price of every book that has the type MYS?

1 answer

Answer

1098172

2026-07-24 21:50

+ Follow

SELECT a.BOOK_CODE, a.TITLE

FROM BOOK a, BOOK b

WHERE a.PRICE > b.PRICE AND b.TYPE = 'MYS'

ReportLike（0）ShareFavorite

Related Questions

Topics to Explore

InstagramTumblrSkypePhotoshopPowerPointPostgreSQLMySQLJavaScriptJavaLinuxStarlinkSpaceXDELLYahoogoogleAndroidExcelMicrosoftWordTikTokAppleiOSiphoneipadWindowsYouTubeAmazon

A-Z Search

ABCDEFGHIJKLMNOPQRSTUVWXYZ0-9

About Us|Disclaimer|Copyright Notice|Infringement Report|Privacy Policy|Contact Us

Copyright © 2026 eLLeNow.com All Rights Reserved.