Query to find the top five employee salaries

• Use the SELECT statement to retrieve the employee salaries

• Order the results in descending order using the ORDER BY clause

• Limit the results to the top five u...read more

Select sal,row num

From emp

Where r1<5;

Select Sal

From (Select Rownum as SINO , Emp.*

From( Select distinct Sal

From Emp

Order by Sal Desc))

Where SINO<=5;