How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 26015 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / naresh
select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
explain advantages of innodb over myisam. : Sql dba
What are the basic sql commands?
Why is pl sql used?
what is the use of friend function? : Sql dba
What is substitution variable?
How do I find duplicates in a single column in sql?
Is record in oracle pl sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What sql does db2 use?
how to create a new table by selecting rows from another table in mysql? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Can a primary key be a foreign key?
What are operators available in sql?
Why is a trigger used?
What is not equal in sql?
