SELECT * FROM STAFF AA WHERE 5 = (SELECT COUNT (SALARY) FROM STAFF W

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

Question Posted / payel

Answer Posted / payel

SELECT * FROM STAFF AA
WHERE 5 = (SELECT COUNT (SALARY) FROM STAFF WHERE SALARY
<= AA.SALARY );

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is cobol db2?

1003

List some fields from sqlca?

1060

What is the default page size of buffer pools?

1123

What is the use of reorg in db2?

1086

What is bufferpool in db2?

1054

What are concurrency issues?

1098

What is database reorganization?

1128

What is nvl in db2?

1096

What is db2 look?

1026

How can the duplicate values be eliminated from db2 select?

1106

List down the types of triggers in the db2 database?

1033

What are the full forms of spufi and dclgen and why are they used?

1091

Explain the benefits you can get from mainframe connect?

972

What is catalog database in db2?

1166

Is db2 free?

1096