| |
GeekInterview.com > Tech FAQs > SQL
| Print | |
Question: How to get fifth maximum salary from the table with out using TOP keywork(without any keywords) in sql server 2000
Can you please guide me about this?
|
| May 05, 2008 03:44:58 |
#7 |
| Imran_Javed |
Member Since: May 2008 Total Comments: 23 |
RE: How to get fifth maximum salary from the table with out using TOP keywork(without any keywords) in sql server 2000Can you please guide me about this?
|
SELECT *
FROM (SELECT ename ,sal,
dense_rank() over (ORDER BY sal DESC) max_sal
FROM emp)
WHERE max_sal= 5; |
| |
Back To Question | |
