how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36864 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4
| Is This Answer Correct ? | 20 Yes | 7 No |
Post New Answer View All Answers
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...
what are aggregate and scalar functions? : Sql dba
what is datawarehouse? : Sql dba
what is the difference between char_length and length? : Sql dba
What are the differences between in and exists clause?
What are the different parts of a package?
Is sqlite thread safe?
What is the difference between function and procedure in pl/sql?
How to start oracle sql developer?
Why we use pl sql?
What is foreign key sql?
What is the requirement of self-join?
What is sql stand for?
What is a relationship and what are they?
How do I delete a trigger?
