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
- 18095 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 is clone table?
Mention the downsides of page level lock.
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 .....
How to execute stored procedures?
What is multi row fetch in db2?
How to compare data between two tables in db2?
What is the role of data manager in the db2 database?
How to view db2 table structure?
What is the use of with ur in db2?
What is bind and rebind in db2?
Before you give the explain statement, what are the prerogatives?
What is check constraint. Explain with example.
What is ibm db2 used for?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How can we retrieve the total number of records in RPG & CLLE?
