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
- 18092 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajib
select max(salary) from staff where salary not in(select
salary from staff order by salary desc fetch first 4 rows
only)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is precompiler in db2?
What is image copy in db2?
Mention the location where the output received from explain statement is stored.
Can there be more than one cursor open for any program?
What is clone table?
Is db2 a mainframe database?
What is host variable?
What is db2? Explain.
Explain about rct in db2?
Which components manage deadlocks in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can you count the number of rows from a table tab?
What is catalog database in db2?
What is runstats utility in db2?
What is the syntax for creating a table in the db2 database?
