مسارات وأدلة برمجية بالعربية، مرتّبة خطوة بخطوة

WITH employees AS (
  SELECT 1 AS id, 'IT' AS department, 9000 AS salary
  UNION ALL SELECT 2, 'IT', 9000
  UNION ALL SELECT 3, 'IT', 7000
), ranked AS (
  SELECT id, department, salary,
         0 AS dr
  FROM employees
)
SELECT id, department, salary
FROM ranked
WHERE dr <= 2;