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
17409 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

How do I add a column in db2?

1000

Explain in detail about buffer manager and its functionalities?

998

Is ibm db2 open source?

1020

Explain about open switch business continuity software?

1074

What is catalog database in db2?

1105

what are bind concepts in db2 cobol?

1036

what is a corelated subquerry?

1067

What is db2 command?

965

What is a storage group (stogroup)?

1191

What is the result of open cursor statement?

1030

Define db2 and its databases?

1007

What is the use of runstats in db2?

1025

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8137

How can you do the explain of a dynamic sql statement?

1019

What is the usage of open cursor command?

1040