SQLize Online / PHPize Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Проверить одинаковые ли данные в таблицах 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
Stuck with a problem? Need help? Ask professionals on our Telegram channel!
Join the channel
Your quersion is posted.
Join our Telegram channel and get answers.
Send
Copy