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
- 29378 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 are pl/sql cursors?
What is the difference between alter trigger and drop trigger statements?
What is synchronized subquery?
What is materialized view. What are different methods of refresh?
Which sql statement is used to return only different values?
What is cursor explain with example?
What is the difference between having and a where in sql?
How to return an array from java to pl/sql?
Which are the different types of indexes in sql?
What are different types of tables in sql?
What is localdb mssqllocaldb?
explain mysql aggregate functions. : Sql dba
What is number function in sql?
Can we use joins in subquery?
what is timestamp in mysql? : Sql dba
