UNION,UNION ALL, EXCEPT and INTERSECT in sql

--First create two table  :-

CREATE TABLE [dbo].[t1](
[id] [int] NULL,
[name] [varchar](50) NULL
) 

CREATE TABLE [dbo].[t2](
[id] [int] NULL,
[name] [varchar](50) NULL
)

--Insert record in first table

insert into t1 values(1,'sk');
insert into t1 values(2,'jitu');
insert into t1 values(3,'Gita');
insert into t1 values(4,'Ram');
insert into t1 values(5,'Sita');

--Insert record in second table

insert into t2 values(1,'sk');
insert into t2 values(2,'ramu');
insert into t2 values(6,'Rajeev');

--INTERSECT


SELECT * FROM t1;






SELECT * FROM t2






<<< SELECT t1.id FROM t1 INTERSECT SELECT t2.id FROM t2

--UNION
SELECT t1.id FROM t1  UNION  SELECT t2.id FROM t2

--UNION ALL

SELECT t1.id FROM t1  UNION ALL  SELECT t2.id FROM t2

--EXCEPT

SELECT t1.id FROM t1  EXCEPT SELECT t2.id FROM t2