How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / naresh
select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can we solve sql error: ora-00904: invalid identifier?
what are set operators in sql? : Sql dba
Who is the owner of mysql database?
What are predefined functions in sql?
what is bcp? When does it used? : Sql dba
how would you get the current date in mysql? : Sql dba
How do I run a script in sql developer?
How do temporal tables work?
What are the types of variables use in pl sql?
What are two statement types in sql?
How does an execution block start and end in pl sql?
Is join same as left join?
What is the difference between mdf and ndf files?
What is the use of stored procedures?
What is sql deadlock?