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
- 30086 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
What are the subsets of sql?
What is an emotional trigger?
What are different types of sql commands?
Explain what is table in a database?
what is the use of set statement in tsql? : Transact sql
What is the most restrictive isolation level? : Transact sql
What is use of trigger?
What is a trigger in sql?
What are the dml statements?
What is PL/SQL Records?
How many parts of a pl sql block are optional?
what is transaction? : Sql dba
What is a join query?
What is scope of pl sql developer in future?
what is a composite primary key ? : Sql dba
