SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(S

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

Question Posted / satish kalynm

10 Answers
18090 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / satish kalynm

SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999
WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(SELECT
MAX(SAL) FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999))));

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What db2 400?

1260

How does a cursor work?

1043

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

What is rebind in db2?

1121

What is the role of schema in the db2 database?

1366

What is the syntax for creating a table in the db2 database?

1150

How can we read records for specific member in CL? AND rpg?

762

What is db2 catalog database?

1093

How do I delete a column in db2?

1157

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

1240

List out the data types available.

1206

What is the difference between plan and package in db2?

1176

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

1113

What is role in db2?

1165

What does db2 plan contain?

1092