how to retrieve the top 3 salaries of the table using rownum
Answer Posted / raghunanda
SELECT * 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
How to display the records between two range in Oracle SQL Plus?
Do stored procedures prevent sql injection?
Mention what are the benefits of pl/sql packages?
How do I view a sql trace file?
What does count (*) mean in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is sql used for?
What is sql exception?
what is column? : Sql dba
What is structural independence and why is it important?
What is the difference between python and sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How do I run pl sql in sql developer?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is the use of count (*) in sql?