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
Explain aggregate functions are available there in sql?
What is compilation error in pl sql?
Where do we use pl sql?
what is the difference between truncate and drop statements? : Sql dba
Is a table valued function object?
Why do we need pl sql?
What is sap sql?
What is indexes?
What are the features of pl sql?
What is rank () in sql?
What is the difference between inner join and left join?
Which join is like inner join?
What is the difference between functions, procedures, and packages in pl/sql?
What is rownum?
What is sql query limit?