window-function-5.sql

SELECT *
FROM
  (
    (SELECT *
     FROM employe
     WHERE category = 'A'
     ORDER BY salary DESC
     LIMIT 2)
    UNION (SELECT *
           FROM employe
           WHERE category = 'B'
           ORDER BY salary DESC
           LIMIT 2)
    UNION (SELECT *
           FROM employe
           WHERE category = 'C'
           ORDER BY salary DESC
           LIMIT 2)
    UNION (SELECT *
           FROM employe
           WHERE category = 'D'
           ORDER BY salary DESC
           LIMIT 2)
    UNION (SELECT *
           FROM employe
           WHERE category = 'E'
           ORDER BY salary DESC
           LIMIT 2)
  ) AS tmp
ORDER BY category, salary DESC;