SELECT DISTINCT TEMP_TAB.SAL
FROM DEDBADM.EMP AS A,
TABLE(SELECT SAL
FROM DEDBADM.EMP E
WHERE A.SAL >= E.SAL) AS TEMP_TAB
ORDER BY SAL DESC
FETCH FIRST 5 ROWS ONLY;


---------+---------+---------+---------+---------+---------
SAL
---------+---------+---------+---------+---------+---------
5000.00
3020.00
3000.00
2975.00
2850.00
DSNE610I NUMBER OF ROWS DISPLAYED IS 5
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page