There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 15183 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajib
select max(salary) from staff where salary not in(select
salary from staff order by salary desc fetch first 4 rows
only)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is check constraint. Explain with example.
How to access db2 tables in mainframe?
Define check constraint.
What is the purpose of rollback and commit?
How do I add a column to an existing table in db2?
What is db2 instance?
Which component is responsible for db2 startup and shutdown?
On which levels locks can be applied?
How and when does the db2 enforces the unique key?
How to check sequence on a table in db2?
What is temporal table in db2?
What is node in db2?
What are the contents of dclgen?
Why do we bind in db2?
