How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 23492 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
Is trigger a stored procedure?
What is package in pl sql with an examples?
Can we use pl sql in mysql?
Is sql a backend language?
What is sql injection vulnerability?
How many types of normalization are there?
What is count * in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
what are the advantages of using stored procedures? : Sql dba
Does truncate require commit?
how would you enter characters as hex numbers? : Sql dba
Which are the different types of indexes in sql?
What is the difference between clustered and non-clustered index in sql?
What are different types of indexes?
How do I view a sql database?
