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 r the comman abends in db2, jcl and cobol???????

2268

What types of tables are there in the db2 database?

1062

What is the physical storage length of date data type?

1260

What is the purpose of rollback and commit?

1203

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1112

What are the two types of logging in the db2 database? Explain them.

1083

Explain what are the various isolation levels possible?

1053

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

1095

How to find schema of a table in db2?

1022

Discuss about db2 bind?

1105

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1282

Which is faster delete or truncate?

1137

What is explain in db2?

1039

What is package in db2 mainframe?

994

What is an instance database?

1063