| Subject: | how do we find nth highest in SQL | |
| Date: | 2006-07-11 22:39:42 | |
| From: | prasanna1729 | |
|
Response to: how do we find nth highest in SQL
|
||
| how do we find nth highest in SQL | ||
Showing messages 1 through 2 of 2.
-
how do we find nth highest in SQL
2006-08-17 04:21:32 navingujar [View]
One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n
-
how do we find nth highest in SQL
2006-08-17 04:21:27 navingujar [View]
One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n
