SQLize Online / PHPize Online  /  SQLtest Online

-- Проверить одинаковые ли данные в таблицах 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 ), Employees_1 as ( select * from Employees union all select 13, 3, 20000 ) SELECT e1.EmployeeID, e1.DepartmentID, e1.Salary, e2.EmployeeID as EmployeeID_1, e2.DepartmentID as DepartmentID_1, e2.Salary as Salary_1 FROM Employees e1 FULL OUTER JOIN Employees_1 e2 ON e1.EmployeeID = e2.EmployeeID WHERE (e1.EmployeeID IS NULL OR e2.EmployeeID IS NULL OR e1.DepartmentID != e2.DepartmentID OR e1.Salary != e2.Salary)