SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(S

There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........

Question Posted / satish kalynm

10 Answers
17762 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / satish kalynm

SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999
WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(SELECT
MAX(SAL) FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999))));

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define data page.

1067

How do I import data from excel to db2?

1071

What is sqlca’s maximum length?

1185

How do I change the column size in db2?

1157

On which levels locks can be applied?

1130

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

How can record locking be achieved in those DB2 versions which do not support it?

1076

What is the difference between spufi and qmf?

1130

What are iseries servers?

1075

What is the use of db2?

1055

What is ibm db2 database?

1002

what is the sqlcode -501

13150

What is dbrm in db2 database?

1115

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044

Explain what are the various isolation levels possible?

1044