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
- 17788 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 is the reason behind not using select * in embedded sql programs?
How to test SQL -911 error while developing COB-DB2 program
Where do you specify them?
How to fetch the last row from the table in SQL (db2)?
How to check table size in db2 sap?
How many databases can be created inside an instance in db2 ?
What are the rules for db2 programming?
What does db2 mean?
What is a db2 table?
Name the lockable units in DB2?
What action db2 takes when a program aborts in the middle of a transaction?
What is deadlock in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How to check last update on table in db2?
What is the physical storage length of the data types date, time, and timestamp?
