There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
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
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 ?
Explain package in db2 and its advantages?
Explain in detail about buffer manager and its functionalities?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How to execute stored procedure in db2 command editor?
If I have a view which is a join of two or more tables, can this view be updateable?
Mention the different locking levels that are available in db2.
Discuss about db2 bind?
How can you do the explain of a dynamic sql statement?
What is the physical storage length of timestamp data type?
Define declaration generator (dclgen).
What is the difference between plan and package in db2?
What is the use of reorg in db2?
What is precompiler in db2?