How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / vijay
select min(salary) from (select rownum r,e.* from employees e order by salary desc) where rownum<=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the nonstandard string types? : Sql dba
How to rename a table?
Why do we use partitions in sql?
Why do we use procedures in sql?
How many sql core licenses do I need?
what is oracle database ? : Sql dba
What is insert command in sql?
what is index? : Sql dba
What is cartesian join in sql?
What is sql performance tuning?
differentiate between float and double. : Sql dba
Why use truncate instead of delete?
Why is a trigger used?
What is minus?
How do I view an execution plan in sql?