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
- 29510 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / avi007
SELECT employee_name,min(salary) FROM ( select distinct
salary from employee order by salary desc)
where rowno<6 group by employee_name;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are actual parameters and formal parameters?
What is bitemporal narrowing?
Mention what is the plv (pl/vision) package offers?
How to run sql*plus commands in sql developer?
What is a natural join?
Write a unique difference between a function and a stored procedure.
Explain the difference between sql and mysql.
What is difference between joins and union?
What is an exception in pl/sql?
Define a temp table?
How to write a query to show the details of a student from students table whose
what are the differences among rownum, rank and dense_rank? : Sql dba
Why stored procedure is better than query?
What are %type and %rowtype for?
what is a trigger? : Sql dba
