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
- 29446 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / mani
select first_name,sal from
(
select first_name,sal from
(
select distinct
sal from employees
order by sal desc
)
where rownum < 5
order by sal
)
where rownum<2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is count * in sql?
What is package in pl sql?
What are the main features of cursor?
How many triggers can be applied on a table?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Inline the values in PL/SQL, what does it mean.?
What is int identity in sql?
How do I view a sql trace file?
What is materialized view. What are different methods of refresh?
What are the types of keys?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
explain advantages of myisam over innodb? : Sql dba
What does truncate mean in sql?
What is the maximum number of rows in sql table?
What is a full join sql?
