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
- 29560 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 inner join faster than left join?
How do I edit a trigger in sql developer?
Why does sql need a server?
How do I run sql profiler?
Where is sql database stored?
How do you explain an index number?
What is asqueryable?
How many primary keys can a table have?
What is the sql case statement?
What is the purpose of normalization?
what is the use of friend function? : Sql dba
What is memory optimized?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
Is merge a dml statement?
