Page 1 of 1

db2

Posted: Wed Sep 27, 2006 1:00 pm
by supriya
1) How to find Nth highest salary using co-related subquery?

Nth highest salary - SQL

Posted: Wed Sep 27, 2006 2:32 pm
by Krishna
Hi supriya,

Here is the query.

Code: Select all

SELECT     *    FROM        TABLEA  E1
WHERE     N =   (SELECT     COUNT(DISTINCT (E2.SAL))
                            FROM         TABLEA E2
                            WHERE      E2.SAL >= E1.SAL)
 

Thanks,
Krishna