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
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