There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 15180 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nagireddy
select max(sal) from emp a where 5=(select count(distinct sal)
from emp b where a.sal<=b.sal);
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is load utility in db2?
How to create backup table in db2?
What is meant by dclgen?
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 parameters are used to control the free space in DB2?
Discuss about db2 bind?
Explain db2.
What is package in db2 mainframe?
What is an instance in db2?
What is the max length of sqlca?
Which is faster delete or truncate?
What is ibm db2 used for?
What are the uses of db2 optimizer?
How and when does the db2 enforces the unique key?
What action db2 takes when a program aborts in the middle of a transaction?
