how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 33983 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / k.thrilok kumar
select rownum, sal from (select * from emp order by sal
desc) where rownum<=3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is database migration?
Why do we use procedures in pl sql?
What is the trigger in sql?
What are the various levels of constraints?
How can you save or place your msg in a table?
how to escape special characters in sql statements? : Sql dba
Explain polymorphism in pl/sql.
How do I view a table in sql?
How do you delete a table?
How do you modify a trigger?
What are the string functions in sql?
What is secondary key?
What is primary key and unique key?
How do I enable sql encryption?
what does it mean to have quoted_identifier on? : Sql dba
