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 deadlock in db2?

583

Explain dclgen.

724

What is rebind in db2?

576

define clustering index.

617

What is iseries database?

597

What are the various data types available in db2?

634

What is query_cache_limit?

545

What is multi row fetch in db2?

608

Which are the db2 tools to protect integrity of the database?

692

What is the physical storage length of timestamp data type?

646

What is the use of value function?

629

What is a bind card?

681

What are concurrency issues?

632

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

747

Why do we bind in db2?

631