how to retrieve the top 3 salaries of the table using rownum

Answer Posted / sumalatha

select top 3 esal from employee order by esal desc

Is This Answer Correct ?    4 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is out parameter used for eventhough return statement can also be used in pl/sql?

800


What is field delimiter?

793


What is a data definition language?

791


How to run sql statements with oracle sql developer?

791


what are the advantages of mysql in comparison to oracle? : Sql dba

704






Why use stored procedures?

774


How do you rank data in sql?

680


What are sql objects?

738


How long will it take to learn pl sql?

689


Define tables and fields in a database

834


Mention what problem one might face while writing log information to a data-base table in pl/sql?

871


what are myisam tables? : Sql dba

721


How do you modify a trigger?

695


What is the difference between sql and t sql?

717


What do you mean by stored procedures?

733