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
- 30110 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 reports view in oracle sql developer?
Does oracle use sql?
How show all rows in sql?
What is data modelling in sql?
How to select random rows from a table?
What is dml statement?
Mention what pl/sql package consists of?
What is oracle pl sql developer?
What is range partitioning?
Show the two pl/sql cursor exceptions.
What is on delete restrict?
What is having clause in sql?
What is sql in oracle?
what is the difference between $message and $$message? : Sql dba
discuss about myisam key cache. : Sql dba
