SQLize Online / PHPize Online  /  SQLtest Online

with employees as ( select 1 as EmployeeID, 1 as DepartmentID, 16858 as Salary, 0 as IsDirector, '1985-01-01' as DateOfBirth union all select 2,1,18794,1,'1985-03-01' union all select 3,1,17257,0,'1985-01-12' union all select 4,1,17654,0,'1988-05-02' union all select 5,1,16262,0,'1992-06-09' union all select 6,2,16650,0,'1986-02-15' union all select 7,2,15211,0,'1987-03-18' union all select 8,2,16117,0,'1995-11-20' union all select 9,2,16958,0,'1994-10-14' union all select 10,2,16495,0,'1997-12-17' union all select 11,2,17629,1,'1989-08-15' union all select 12,3,17352,0,'1989-09-12' union all select 13,3,16692,0,'1986-08-05' union all select 14,3,17154,0,'1992-11-14' union all select 15,3,16128,0,'1991-03-19' union all select 16,3,19094,1,'1988-04-17' union all select 17,3,15208,0,'1993-04-20' union all select 18,3,17091,0,'1996-08-21' union all select 18,3,17091,0,'1996-08-21' ) select * from employees