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
- 17767 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
Is the primary key a clustered index?
What is the information associated with sysibm.syslinks table?
List out the data types available.
What r the comman abends in db2, jcl and cobol???????
What is the use of reorg in db2?
What is explain in db2?
What is the physical storage length of time data type?
How to view db2 table structure?
What is a dbrm in db2?
What are the full forms of spufi and dclgen and why are they used?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is a db2 schema?
How to check last update on table in db2?
What is nvl in db2?
Define buffer pool.
