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
- 18084 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kasyapa
select * from emp A where 4 = (select count(*) from emp B
where A.sal<B.sal)
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How would you find out the total number of rows in a db2 table?
Which isolation level provides maximum concurrency?
What does db2 blu stand for?
How is the value function used?
What is a db2 package?
What is bufferpool in db2?
How to check sequence on a table 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?
How to resolve deadlock issue
How to create db2 table in mainframe?
What are foreign keys in db2?
Explain what are the various isolation levels possible?
When the like statement is used?
What is the maximum number of columns in a db2 table?
How do I delete a table in database?
