A C
-----
2 4
3 4
4 3
5 2
7 2
9 5
6 4
select title
from book as B
where (select count(*)
from book as T
where T.price > B.price) < 5
Database Management Systems | Set 8 A C ----- 2 4 3 4 4 3 5 2 7 2 9 5 6 4 select title from book as B where (select count(*) from book as T where T.price > B.price) < 5 .
A C
-----
2 4
3 4
4 3
5 2
7 2
9 5
6 4
select title
from book as B
where (select count(*)
from book as T
where T.price > B.price) < 5