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
- 29384 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
Is keyword pl sql?
Can we insert data into materialized view?
What is benefit of creating memory optimized table?
How does cross join work?
Does pdo prevent sql injection?
Why triggers are used?
what is msql? : Sql dba
What is the need of a partition key?
What is bulk compiling in pl/sql.?
what are the different type of sql's statements ? : Sql dba
What is difference between stored function and application function?
What version is sql?
Can I learn sql in a week?
What is the use of non clustered index?
What are the types of keys?
