There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
Answer Posted / udhay
SELECT MAX(salary)
FROM employees
WHERE salary
NOT IN (SELECT TOP 4 salary FROM employees ORDER BY salary
DESC)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is a buffer in memory?
What is the connection string to connect to the DB2 Database ?
What's The Error Code For Unique Index Voilation?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is host variable?
What is null value in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
what is the responsibility of the construction superintendent
How is deadlock resolved?
How would you find out the total number of rows in a db2 table?
what is the sqlcode -501
What is a db2 table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is precompiler in db2?
What is dbrm in db2 database?