View previous topic :: View next topic
|
Author |
Message |
raviprasath_kp Warnings : 1 New User
Joined: 20 Feb 2005 Posts: 65 Location: chennai
|
|
|
|
Hi i have one db2 table
i want to print first 5 max salary
any one can suggest some qurey for that |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
raviprasath_kp wrote: |
Hi i have one db2 table
i want to print first 5 max salary
any one can suggest some qurey for that |
Here it is. Expect terrible response time.
Code: |
SELECT MAX(SALARY) FROM SALARYS
UNION ALL
SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS)
UNION ALL
SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS))
UNION ALL
SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS)))
UNION ALL
SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS
WHERE SALARY < (SELECT MAX(SALARY) FROM SALARYS))))
ORDER BY 1 DESC;
|
|
|
Back to top |
|
|
Abirami.YN
New User
Joined: 16 Jul 2005 Posts: 15 Location: India - Chennai
|
|
|
|
Hi,
Try this query to fetch first 5 maximum salary amount
SELECT SALARY FROM SALTABLE
ORDER BY SALARY DESC
FETCH FIRST 5 ROWS ONLY
Regards
Abirami |
|
Back to top |
|
|
|