Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (6.1k points)
How can I find the top three highest salary in the emp table in oracle?

1 Answer

0 votes
by (12.7k points)

The following query should do it.

    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:

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories