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
- 29471 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / raghuvir
select * from employee where salary = (
select min(salary) from (
select distinct(salary) from employee
order by salary desc)
where rownum <=5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is clause in sql?
What is sql partition?
How do you update a value in sql?
Can you load data into multiple tables at once? : aql loader
Where is sql database stored?
How many sql are there?
What is a common use of group by in sql?
What is data definition language?
what are null values? : Sql dba
What are pl/sql cursors?
What are the types of records?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is data control language (dcl)?
What are the advantages of indexing?
What is right join sql?
