How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 26011 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / ajeet
SELECT first_name, salary FROM employees E1
WHERE (5) = (SELECT COUNT(DISTINCT(E2.salary))
FROM employees E2
WHERE E1.salary < E2.salary)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
The in operator may be used if you know the exact value you want to return for at least one of the columns.
How do I make my sql query run faster?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How to read/write files from pl/sql?
What is the difference between syntax error and runtime error?
explain primary keys and auto increment fields in mysql : sql dba
What is the usage of nvl function?
How can we debug in PL/SQL?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What does the hierarchical profiler does?
what are the join types in tsql? : Transact sql
What is substitution variable?
What is sqlca in powerbuilder?
Explain what is a view?
Explain what is a database?
