-
Get the name of 3rd most expense item
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)?
-
Expert Member
Re: Get the name of 3rd most expense item
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.
-
Junior Member
Re: Get the name of 3rd most expense item
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules