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
- 30070 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 inner join faster than left join?
Does access use sql?
Which command is used to delete a package?
what are rollup and cube in t-sql? : Transact sql
What are synonyms in sql?
Name three sql operations that perform a sort.
How are functions and procedures called in PL/SQL?
Does oracle use sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
How many types of privileges are available in sql?
What is bulk collect in pl sql?
how can we repair a mysql table? : Sql dba
What is audit logout in sql profiler?
What are aggregate and scalar functions?
Is inner join same as self join?
