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
- 30081 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 is scope and visibility in PL/SQL?
What is use of package in pl sql?
Can we use insert statement in function?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is bulk compiling in pl/sql.?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do I use google cloud in sql?
How many clustered indexes can you have?
What is a subquery in sql?
What is group by in sql?
When you have to use a default "rollback to" savepoint of plvlog?
Why function is used in sql?
what is oracle database ? : Sql dba
What are the two types of periodical indexes?
What is the mutating table and constraining table?
