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 -- e.*, -- e_1.* -- from -- Employees e -- full join Employees_1 e_1 -- on e.EmployeeID = e_1.EmployeeID -- and e.DepartmentID = e_1.DepartmentID -- and e.Salary = e_1.Salary -- -- where -- e.EmployeeID = e_1.EmployeeID -- and e.DepartmentID = e_1.DepartmentID -- and e.Salary = e_1.Salary SELECT * FROM (SELECT * FROM Employees UNION ALL SELECT * FROM Employees_1 ) q GROUP BY EmployeeID, DepartmentID, Salary HAVING COUNT(*) > 1