Back
The following query should do it.
SELECT *FROM ( SELECT *FROM emp ORDER BY Salary desc ) WHERE rownum <= 3 ORDER BY Salary ;
Want to be a SQL expert? Come and join this SQL Certification by Intellipaat.
If you want to know more about SQL, refer to the below SQL tutorial video that will help you out in a better way:
31k questions
32.8k answers
501 comments
693 users