How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / kishore
select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;
Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is a column in a table?
What is difference between joins and union?
What does (*) mean in sql?
what is sql profiler? : Sql dba
What has stored procedures in sql and how we can use it?
What is full form of rtm?
How to display the current date in sql?
how are mysql timestamps seen to a user? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
what is the different between now() and current_date()? : Sql dba
What does count (*) mean?
Show the two pl/sql cursor exceptions.
Is ms sql is free?
What is meant by cursor in sql?
What are different types of sql?