Get the name of 3rd most expense item

[Geek_Guest]

Question asked by visitor Steve

What will be the query to get the name of 3rd most expense item from table Item (ID,Name,Price)?

[Barbie]

The same thing is already discussed for 788th greatest in the following link:

http://www.geekinterview.com/talk/24...st-salary.html

I think this will help you.

[siddhartha_sanyal]

To get the 3rd most expensive item :

Select b.price , b.Id , b.name
from Item b, Item b
where
b.price <= a.price
group by (b.price)
having count(b.price) = 3