-- Проверить одинаковые ли данные в таблицах
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)
Telegram: DB developers channel