id  emp_name    emp_mailid            salary
2   dinesh      dinesh@gmail.com       5000
3   ganesh      ganesh@gmail.com       6000
6   ramesh      ramesh@gmail.com       4500
10  suresh      suresh@gmail.com       10000
11  rajesh      rajesh@gmail.com       15000
15  kamesh      kamesh@gmail.com       16000
16  kamalesh    kamalesh@gmail.com     7800
19  neelash     neelash@gmail.com      12563
20  rajan       rajan@gmail.com        156231
22  vignesh     vignesh@gmail.com      45220
30  rubesh      rubesh@gmail.com       78000
31  john        john@gmail.com         6522

select *
  from
  (
    select
        salary
          ,dense_rank() over (order by salary desc) ranking
    from   test
  )
  where ranking = 1