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

Define db2.

1123

what is the role of the cursor in db2?

1077

What is consistency token in db2?

1155

How do I import a csv file into db2?

1004

What does a deadlock mean in DB2?

1180

What r the comman abends in db2, jcl and cobol???????

2271

What are the benefits of using the db2 database?

1246

What is a db2 table?

1028

What is the maximum No of rows per page?

1079

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1208

what is db2 restart?

2167

What is the role of union all and union

1134

What is meant by explain?

1143

How do I delete a column in db2?

1116

What is runstats and reorg in db2?

1319