How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 23555 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
what is the difference between union and union all? : Sql dba
What are analytical functions in sql?
What is set transaction?
Explain foreign key in sql?
How do I start sql profiler?
What is trigger point?
Why do we use procedures in sql?
What is ttitle and btitle?
Does oracle use sql?
What steps server process has to take to execute an update statement?
what is data control language? : Sql dba
How are sql commands classified?
What are literals in sql server?
what is the syntax used for partition in tsql? : Transact sql
What is group function in sql?
