|Subject:||query for nth max|
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)
Showing messages 1 through 1 of 1.
query for nth max
2007-10-25 05:02:21 jolly_cet [View]