Women in Technology

Hear us Roar



Subject:   how do we find nth highest in SQL
Date:   2006-08-17 04:21:32
From:   navingujar
Response to: how do we find nth highest in SQL

One more way, select min(sal) from (select distinct sal from emp order by sal desc) where rownum <=n