Use DENSE_RANK instead of ROW_NUMBER() with GROUP BY , as it will take only 1 map-reduce job to achieve it as compared to 2 map-reduce jobs by latter one. select * from ( select salary, DENSE_RANK() over (ORDER BY salary DESC) as row_no from emp) res where res.row_no = 2; ... View more