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
- 18078 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abhusha
SELECT SAL FROM EMP A
WHERE 5 = (SELECT COUNT(*) FROM EMP B
WHERE B.SAL >= A.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain db2.
Name the various locking levels available?
What are foreign keys 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?
Explain correlated sub-queries.
List out the data types available.
What is a db2 schema?
What is the purpose of rollback and commit?
Mention the definition of cobol in varchar field.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How can the duplicate values be eliminated from db2 select?
Define buffer pool.
What is a db2 package?
What is check constraint. Explain with example.
How can you classify the locks in db2?
