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
- 17776 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sachin
SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY <
(SELECT MAX(SALARY) FROM EMP WHERE SALARY ))))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What does db2 stand for?
What is dbrm library?
How to take backup of table in db2?
Can we insert update delete in view?
Why do we bind in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How and when does the db2 enforces the unique key?
What is multi row fetch in db2?
How to find the number of rows in a db2 table?
What does reorg do in db2?
What is db2 and what is the use of db2 optimizer?
What is precompiler in db2?
What do you mean by storage group (stogroup)?
What is difference between rollback and commit?
Is ibm db2 open source?
