How to get employee name from employee table which is the
fiveth highest salary of the table
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
what tools available for managing mysql server? : Sql dba
How can I delete duplicate rows?
What is the plv (pl/vision) package offers?
Is oracel sql developer written in java?
What is self-join and what is the requirement of self-join?
What are primary key and foreign key and how they work?
Is natural join and inner join same?
What is primary key in db?
Can a foreign key have a different name?
How to rename a table?
What are the query optimization techniques?
How do I write a sql query in pgadmin 4?
Can a foreign key be null?
What is the difference between clustered and non-clustered index in sql?
What is package in pl sql with an examples?