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
- 17412 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abhusha
SELECT SAL FROM EMP A
WHERE 5 = (SELECT COUNT(*) FROM EMP B
WHERE B.SAL >= A.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What types of tables are there in the db2 database?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is data manager?
What is declare cursor?
What are packages in db2?
Explain package in db2 and its advantages?
Is db2 a mainframe?
What are bind parameters in db2?
What language is db2 written in?
What is db2 bind?
What is precompiler in db2?
What is the advantage in De-normalizing tables in DB2?
Define declaration generator (dclgen).
What are the uses of db2 optimizer?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
