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
- 29374 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 are the various levels of constraints?
Can we create clustered index without primary key?
Difference between global and parameter variables?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how to convert dates to character strings? : Sql dba
How can the performance of a trigger be improved?
What is the basic structure of an sql?
What are the methods of filing?
What are sql objects?
What is sql resultset?
Can primary key be changed?
What are the possible values for the boolean data field?
What is the difference between null value, zero, and blank space?
Is merge a dml statement?
Which is better cte or subquery?
