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

Which command is used to connect to a database in DB2 ? Give the Syntax.

1153

What is cloudant database?

1160

What is a dbrm in db2?

1081

Which component is used to execute the sql statements?

1149

What are bind parameters in db2?

1099

What is the advantage in De-normalizing tables in DB2?

1238

What is null value in db2?

1078

How to create backup table in db2?

1150

What is the maximum length of sqlca?

1620

Is db2 a mainframe?

1098

What happens in bind step in a db2 program?

1014

Can one database have multiple instances?

1097

What is explain in db2?

1080

Can we delete records from view?

1024

Which command is used to remove all rows from a table?

1183