| Subject: | how do we find nth highest in SQL | |
| Date: | 2005-10-30 09:21:35 | |
| From: | bhaskarreddy | |
|
Response to: how do we find nth highest in SQL
|
||
|
select * from emp e where 1=(select count(distinct sal) from emp where e.sal<=sal) if u want to print the second highest sal. replace 1 with 2. |
||
Showing messages 1 through 2 of 2.
