SQLize | PHPize | SQLtest

WITH RankedSalaries AS ( SELECT d.department_name AS DEPARTMENT, e.emp_no AS EMP_NO, e.first_name AS FIRST_NAME, e.last_name AS LAST_NAME, e.salary AS SALARY, DENSE_RANK() OVER (PARTITION BY d.department_name ORDER BY e.salary DESC) AS salary_rank FROM your_employees_table e -- Замените на имя вашей таблицы сотрудников JOIN your_departments_table d ON e.department_id = d.department_id -- Замените на имя вашей таблицы подразделений ) SELECT DEPARTMENT, EMP_NO, FIRST_NAME, LAST_NAME, SALARY FROM RankedSalaries WHERE salary_rank = 1 ORDER BY SALARY DESC; ; SELECT 'Last_query_cost' AS "Variable_name", 0 AS "Value" FROM RDB$DATABASE;