How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 25988 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 pragma in sql?
What is data profiling in sql?
What is data modelling in sql?
What is the difference among union, minus and intersect?
What does partition by mean in sql?
How do I run a sql query?
Does mysql support pl sql?
Is sql dba a good career? : SQL DBA
What is dialect in sql?
What is keys and its types?
The select into statement is most often used to create backup copies of tables or for archiving records?
how many groups of data types? : Sql dba
what is column? : Sql dba
Which is better trigger or stored procedure?
Why is pl sql needed?
