create table
CREATE TABLE mgm(name varcha(20),no int,addr varchar(20),dept varchar(20),country varchar(20),salary int)
insert some values in columns
following query used find firs,second,third rank
select name,no,addr,dept,country,salary from (select dense_rank() over (order by salary desc) as ranking,name,no,addr,dept,country,salary from mgm)a where a.ranking=1
a.ranking=1 //find first rank in table
a.ranking=2= // find second rank in table