|
View previous topic :: View next topic
|
| Author |
Message |
raviprasath_kp
Warnings : 1
New User
Joined: 20 Feb 2005
Posts: 65
Location: chennai
|
|
|
|
hi i want to print 4th maximum salary from emp table
any qurey please sugest me |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| any qurey please sugest me |
Sorry to be a grump, but now that you've been here for over 2 years, you would hopefully be familiar with the forum tool that lets you do a search. . .  |
|
| Back to top |
|
|
prasadvrk
Active User
Joined: 31 May 2006
Posts: 200
Location: Netherlands
|
|
|
|
Hope you get the answer from the link ibmmainframes.com/viewtopic.php?t=16311 provided by Super K
which is
SELECT MAX(SALARY) FROM EMP_TABLE A WHERE 4=(SELECT COUNT(*) FROM EMP_TABLE B WHERE A.SALARY<=B.SALARY); |
|
| Back to top |
|
|
|
|
