Women in Technology

Hear us Roar



Subject:   how do we find nth highest in SQL
Date:   2009-10-13 12:05:05
From:   Sandip D
Response to: how do we find nth highest in SQL

HI Apporva,
I think this is also correct,
but can't u try this out, which is more simple :-


SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);


Enter value for n: 2
SAL
---------
3700