--Except: Get the records in table_1 but not in table_2 --Intersect:Get the records which in table_1 and table_2 ...
UNPIVOT (NoEmp for DepartmentName IN ( [Production],[Engineering], [Sales])) AS ok -- Task 2. Đọc bổ sung kiến thức về Set operators (Tham khảo: https ...