db2
Posted: Wed Sep 27, 2006 1:00 pm
1) How to find Nth highest salary using co-related subquery?
Mainframe programmer forum
http://www.mainframegurukul.com/ibmmainframeforums/
http://www.mainframegurukul.com/ibmmainframeforums/viewtopic.php?f=8&t=1146
Code: Select all
SELECT * FROM TABLEA E1
WHERE N = (SELECT COUNT(DISTINCT (E2.SAL))
FROM TABLEA E2
WHERE E2.SAL >= E1.SAL)