There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
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 type of database is db2?
What is node in db2?
Highlight all the advantages that are attached to a package.
What is difference between rollback and commit?
List down the data types in the db2 database.
What is the use of commit in db2?
What is db2 bind process?
How to find primary key of a table in db2?
Discuss about db2 bind?
What is a Foreign Key?
What is access path in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Outputs of explain are with matchcols = 0. What does this signify?
What is db2 catalog database?