Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 28556 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / mani
select first_name,sal from
(
select first_name,sal from
(
select distinct
sal from employees
order by sal desc
)
where rownum < 5
order by sal
)
where rownum<2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is vs as in pl sql?
What are the different operators available in sql?
how to include comments in sql statements? : Sql dba
What is record variable?
Enlist some predefined exceptions?
What is dml statement?
How do I start sql profiler?
Difference between table function and pipelined function?
What are the built in functions of sql?
Can there be more than one function with a similar name in a pl/sql block?
What is natural join in sql?
What happens when a trigger is associated to a view?
Why do we need cursor in pl sql?
Are subqueries faster than joins?
What is pl/sql table? Why is it used?
