select p.emp_id,p.name,p.salary from
(select emp_id,name,salary,dense_rank()over( order by 
salary desc)maxrank,
dense_rank()over( order by salary asc)minrank from test)p
where maxrank=2 or minrank=2