SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE department (id int(11), name varchar(100)) ; CREATE TABLE employee (id int(11), department_id int(11), chief_id int(11), name varchar(100), salary int(11)) ; INSERT INTO department (id, name) VALUES (1, "D1"), (2, "D2"), (3, "D3") ; INSERT INTO employee (id, department_id, chief_id, name, salary) VALUES (1, 1, 5, "John", 100), (2, 1, 5, "Misha", 600), (3, 2, 5, "Eugen", 300), (4, 2, 5, "Tolya", 400), (5, 1, NULL, "Stepan Chief", 500); WITH tmp AS (SELECT department.name as department_name, employee.name, ROW_NUMBER() OVER (PARTITION BY department_id) AS rownum FROM employee LEFT JOIN department ON employee.department_id = department.id) SELECT * FROM tmp WHERE rownum <= 2