Oracle basic query to view rankings

1-method 1 for finding the top 6-10 employees: selectemployee, salaryfrom (selectemployee, salary, row_number () over (orderby

1-evaluate the top 6-10 employees: select employee, salary from (select employee, salary, row_number () over (order

1-find the top 6-10 employees

Method 1:

Select employee, salary
From (
Select employee, salary, row_number () over (order by salary desc) r
From salary_table
)
Where r between 6 and 10;

==============================================

Method 2:
Select employee, salary
From (
Select employee, salary, rank () over (order by salary desc) r
From salary_table
)
Where r between 6 and 10;

For more information about Oracle, see the Oracle topic page? Tid = 12

,