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
Is schema the same as database?
What is db2 bind process?
What is a db2 collection?
What is the function of logging in the db2 database?
Which are the db2 tools to protect integrity of the database?
Explain about cursor stability?
What is ibm db2 client?
Explain about dbrm.
What is universal database?
How do I start db2 in windows?
What is explain plan in db2?
What are union and union all?
what is a corelated subquerry?
What is cascading rollback?
What is the physical storage length of time data type?