There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
Answer Posted / sachin
SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY ))))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What's The Error Code For Unique Index Voilation?
What is db2? Explain.
How to connect to db2 database from windows command line?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What does db2 stand for?
How do I start db2 in windows?
What are bind parameters in db2?
What is db2 instance?
What is the maximum length of sqlca?
What is db2 and what is the use of db2 optimizer?
B37 abend during spufi?
What parameters are used to control the free space in DB2?
How connect db2 database to datastage?
What is a system catalog table in db2?
What is meant by union and union all?