Women in Technology

Hear us Roar



Subject:   how do we find nth highest in SQL
Date:   2009-10-13 11:57:45
From:   Sandip D
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
---------
3700
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • how do we find nth highest in SQL
    2010-03-06 20:24:30  Sikindar [View]

    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