There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........
- 10 Answers
- 15171 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / udhay
SELECT MAX(salary)
FROM employees
WHERE salary
NOT IN (SELECT TOP 4 salary FROM employees ORDER BY salary
DESC)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
Why select is not preferred in embedded sql programs?
What is declare cursor?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are host variables in db2?
Is the primary key a clustered index?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do I start db2 in windows?
is it compulsory commitment control in journal?
What is db2 catalog database?
What types of tables are there in the db2 database?
How to connect to db2 database from windows command line?
What is buffer pool?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is a dbrm in db2?
