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
- 17651 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
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to take backup of table in db2?
What is reorg and runstats in db2?
What is meant by dclgen?
What is db2 command?
What is the use of dclgen in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is lock escalation in db2?
How do I change the column size in db2?
Mention the various locks that are available in db2.
How many types of page locks can be held in db2?
Is it possible using max on a char column?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the difference between oracle and db2?
