SELECT SAL FROM EMP A WHERE 5 = (SELECT COUNT(*) FROM EMP B WHERE B.SAL &

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

Question Posted / abhusha

Answer Posted / abhusha

SELECT SAL FROM EMP A
WHERE 5 = (SELECT COUNT(*) FROM EMP B
WHERE B.SAL >= A.SAL)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is cursor with hold option in db2?

612

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

705

What is concurrency?

709

Explain in detail about buffer manager and its functionalities?

558

What are catalog tables in db2?

604

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

582

How do I add a column to a table in db2?

616

What is dbrm library?

578

What are the various data types available in db2?

630

What type of database is db2?

523

Define buffer pool.

623

What is bind plan?

606

How connect db2 database to datastage?

761

What is iseries database?

596

Explain about cursor stability?

619