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
- 29536 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / kishore
select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is difference between joins and union?
What is cursor in pl sql?
What are instead of triggers?
How to order siblings in oracle hierarchy queries?
what is normalization? : Sql dba
How do I install sql?
Why select is used in sql?
What is database sql?
How to display the records between two range in Oracle SQL Plus?
How many commands are there in sql?
What is the difference between a primary key and a clustered index?
What do you understand by case manipulation functions?
What are some predefined exceptions in pl/sql?
What pl/sql package consists of?
Why we use sql profiler?
