Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 29451 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 is sqlite used for?
How do I count duplicates in sql?
If a cursor is open, how can we find in a pl/sql block?
Which is better varchar or nvarchar?
what are wild cards used in database for pattern matching ? : Sql dba
What is record type in pl sql?
What are analytical functions in sql?
What is the main difference between sql and pl/sql?
How do I quit sql?
Explain the uses of control file.
How to select random rows from a table?
Where do we use pl sql?
How do you explain an index number?
what are the differences among rownum, rank and dense_rank? : Sql dba
what is a trigger? : Sql dba
