How to fetch top 2 record through group by

Hi Shubham,


SELECT * FROM

            (SELECT
                 name,department,salary
                 ,dense_rank() OVER ( partition by department ORDER BY salary desc) as ranking
             FROM test1) a
WHERE a.ranking <=2



Thanks