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
- 17799 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satish kalynm
SELECT * FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999
WHERE SAL<(SELECT MAX(SAL) FROM T999 WHERE SAL<(SELECT
MAX(SAL) FROM T999 WHERE SAL<(SELECT MAX(SAL) FROM T999))));
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a db2 tablespace?
Which are the db2 tools to protect integrity of the database?
List out the three types of page locks that can be held.
Give a brief description of db2 isolation levels?
Which component is used to execute the sql statements?
What is performance tuning db2?
What is a bind card?
Explain the benefits you can get from mainframe connect?
What is commit in db2?
Mention the definition of cobol in varchar field.
How to check table size in db2 sap?
What is database reorganization?
Name the various locking levels available?
What is the difference between cursor stability and repeatable read isolation levels?
How would the varchar column remarks defined?
