SQLize Online / PHPize Online  /  SQLtest Online

-- Вывести топ 3 сотрудника с самой высокой зарплатой в каждом отделе with Employees as ( select 1 as EmployeeID, 1 as DepartmentID, 10000 as Salary union all select 2, 1, 11000 union all select 3, 1, 12000 union all select 4, 1, 16000 union all select 5, 1, 15500 union all select 6, 1, 17000 union all select 7, 2, 15000 union all select 8, 2, 16000 union all select 9, 2, 17000 union all select 10, 2, 12000 union all select 11, 2, 14000 union all select 12, 2, 11000 ) select * from Employees