How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 23553 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
What are the different sql languages?
If a cursor is open, how can we find in a pl/sql block?
What is sp_helptext?
What is a sql schema used for?
Mention what are the benefits of pl/sql packages?
What is aggregate function in sql?
What is %s in sql?
what are date and time data types in mysql? : Sql dba
differentiate between float and double. : Sql dba
Explain ttitle and btitle.
How do I count duplicates in sql?
What is gpt format?
What is your daily office routine?
Will truncate release space?
How many types of cursors supported in pl/sql?
