Subject:   how do we find nth highest in SQL
Date:   2010-03-06 20:24:30
From:   Sikindar
Response to: how do we find nth highest in SQL

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
-------
3000