There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 15135 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 isolation level in db2?
What is meant by union and union all?
How to connect to db2 database from windows command line?
What parameters are used to control the free space in DB2?
What is the maximum length of sqlca?
What are foreign keys in db2?
What is a db2 collection?
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 ?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is load replace in db2?
What is view db2?
What is copy pending and check pending in db2?
Why cursor is used in db2?
Mention the various locks that are available in db2.
Explain in brief how does db2 determine what lock-size to use?
