write a query for the fifth highest salary?
- 17 Answers
- 19484 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / nitin bisht
SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to do Data integrity testing? Who does this testing (Developer or tester)?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
How to implement database security?
Display the employees whose salary is less than average salary.
Write a query to retrieve for many to many relationships?
What does currency type mean in database?
Which is the best graph database?
5. Explain about relational algebra.
What is the role of tester in discovery(in Checklist)?
What is sharded database?
Should I store images in database?
Is data lake a database?
What is the advantage of varchar2 over char?
Data structure used to implements a menu:
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
