window-function-4.sql

SELECT *
FROM (
       SELECT
         *,
         row_number()
         OVER ordered_report_by_category
       FROM
         employe
       WINDOW ordered_report_by_category AS (
         PARTITION BY
           category
         ORDER BY
           salary DESC
         RANGE
         BETWEEN UNBOUNDED PRECEDING
         AND UNBOUNDED FOLLOWING
       )
     ) tmp
WHERE
  row_number <= 2
;