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 null indicator in cobol db2?

1041

How to connect to db2 database from windows command line?

1038

What is the difference between cursor stability and repeatable read isolation levels?

1151

What is the usage of open cursor command?

1082

How do I add a column in db2?

1029

How do we specify index to include or not during bind process.

2107

What are the different types of base tables?

1071

What is a db2 tablespace?

1045

What is the role of union all and union

1103

What is the difference between oracle and db2?

1074

What is the maximum No of rows per page?

1052

Outputs of explain are with matchcols = 0. What does this signify?

1041

What is the role of data manager in the db2 database?

1091

What is access path in db2?

968

What is lock escalation in db2?

1004