- Tutorials
- Courses
Data Structure
Java
Python
HTML
Interview Preparation
GATE | CS | 2005 | DBMS | SQL | Question 77
Last Updated :
Discuss
Comments
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
Titles of the four most expensive books
Title of the fifth most inexpensive book
Title of the fifth most expensive bookTitles of the five most expensive books
Titles of the five most expensive books
Share your thoughts in the comments
GeeksforGeeks
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy