-
The relation book (title, price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list?
select title
from book as B
where (select count (*)
from book as T
where T. price > B. price) < 5
-
- Title of four most expensive book
- Title of fifth most inexpensive book
- Titles of fifth most expensive book
- Titles of five most expensive book
- Title of four most expensive book
Correct Option: D
The computation is as follows
1. Select the name of the title
2. title is selected from the book
3. Initiates a count
4. consider book as T
5. compute the title of five most expensive books
