GATE CSE 2005 | Question: 77, ISRO2016-55

Question

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

• A. Titles of the four most expensive books
• B. Title of the fifth most inexpensive book
• C. Title of the fifth most expensive book
• D. Titles of the five most expensive books

Comments

will be easy to see if we think like ( B.price <T.price )

---

This question again got repeated in yesterday’s BARC exam 2020 second attempt

Answer 1

${\color{Blue} 5} $ ${\color{Blue} most} $ ${\color{Blue}expensive } $ ${\color{Blue}books } $

Just make a random table, and then, use two pointers T and B, now, just iterate the T pointer for each of B pointer

You will realise, this is like a nested for loop implementation.

This property is the soul of nested sub queries

You have to take example and solve

Now How easy it becomes

 

Thanks

Shashank