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
- 17760 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
Explain in detail about buffer manager and its functionalities?
List some fields from sqlca?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Why db2 is called db2?
What is a db2 table?
What is a bind in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are bind parameters in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is precompiler in db2?
Explain db2.
What is reorg and runstats in db2?
What is the difference between cursor and select statement?
What are host variables in db2?
B37 abend during spufi?
