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
- 17411 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
Which isolation level provides highest data integrity?
Explain in detail about buffer manager and its functionalities?
How to access db2 tables in mainframe?
What is cobol db2?
Define db2.
What do you mean by rollback?
How would you find out the total number of rows in a db2 table?
Define check constraint.
What is explain plan in db2?
How can you find out the # of rows updated after an update statement?
What are the contents of a dclmgen?
How to find the number of rows in db2 tables?
What is host variable in db2 cobol?
What is null indicator in cobol db2?
What are iseries servers?
