Interested to Buy Any Domain ? << Click Here >> for more details...
There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 17664 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
How do I optimize a query in db2?
What is consistency token in db2?
How does cobol compile db2 program?
How to fetch the last row from the table in SQL (db2)?
How do you find the maximum value in a column in db2?
define clustering index.
How is deadlock resolved?
How do I add a column to an existing table in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How do I delete a column in db2?
How do I import a csv file into db2?
What is meant by dclgen?
Can there be more than one cursor open for any program?
What is scrollable cursor in db2?
What does db2 mean?
