How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 26012 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / m haribaskar
Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary <= b.Salary )
| Is This Answer Correct ? | 25 Yes | 7 No |
Post New Answer View All Answers
How to run pl sql program in mysql?
Does view contain data?
Is primary key a clustered index?
Can we change the table name in sql?
What do you mean by query optimization?
Which join is default?
What are aggregate and scalar functions?
What does plv msg allows you to do?
What are pl/sql cursor exceptions?
What is self-join and what is the requirement of self-join?
what is user defined functions? : Sql dba
what is a join? : Sql dba
How do I view a view in sql?
How can we store rows in PL/SQL using array?
What is a database? Explain
