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
- 29379 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
Define implicit and explicit cursors.
Show the two pl/sql cursor exceptions.
What are joins in sql?
What is the difference between inner join and outer join?
What does select * from mean in sql?
What is sql and how does it work?
What is compute?
which types of join is used in sql widely? : Sql dba
Is microsoft sql free?
What does an inner join do?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is difference between nchar and nvarchar?
Can you selectively load only those records that you need? : aql loader
what is the difference between primary key and unique key? : Sql dba
What is date functions?
