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
- 28579 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
Mention what are different methods to trace the pl/sql code?
what is the command line end user interface - mysql? : Sql dba
What are predefined functions in sql?
What is the difference between a primary key and a clustered index?
Explain the order of sql statement execution?
Can we create foreign key without primary key?
Why do you partition data?
how can we optimize or increase the speed of a mysql select query? : Sql dba
what is sql in mysql? : Sql dba
What is the use of procedures?
how can you create an empty table from an existing table? : Sql dba
What is union and union all keyword in sql and what are their differences?
how many values can the set function of mysql take? : Sql dba
What is delimiter in pl sql?
How do I view tables in mysql?
