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
- 18080 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / udhay
SELECT MAX(salary)
FROM employees
WHERE salary
NOT IN (SELECT TOP 4 salary FROM employees ORDER BY salary
DESC)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What does db2 blu stand for?
What is collection in db2 bind?
What is a cursor in programming?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the role of data manager in the db2 database?
How is the value function used?
What is the maximum length of sqlca?
What is the purpose of rollback and commit?
What is the max length of sqlca?
How can we retrieve the total number of records in RPG & CLLE?
How do you select a row using indexes in db2?
How do I optimize a query in db2?
What's The Error Code For Unique Index Voilation?
How do I add a column to a table in db2?
How is a typical db2 batch pgm executed?
