Intersect ,Except in Sql(Set Operators)

Intersect ,Except in Sql(Set Operators);
keywords : intersect,except,set operators

Table Scripts:
create table PermanantCustomer
(
CustomerId int,
Name varchar(100),
Country varchar(100)
)

insert into PermanantCustomer values(1,'Arun','India')
insert into PermanantCustomer values(2,'kumar','India')
insert into PermanantCustomer values(3,'Sara','Uk')

create table TemporaryCustomer
(
CustomerId int,
Name varchar(100),
Country varchar(100)
)

insert into TemporaryCustomer values(1,'Sajan','UK')
insert into TemporaryCustomer values(2,'kumar','India')
insert into TemporaryCustomer values(3,'Meera','India')

--Set Operators
---Intersect and Except
-- returns distinct values by comparing the results of two queries.

--Intersect returns any distinct values returned by both the query on the left and right sides of the Intersect operand
select * from PermanantCustomer
select * from TemporaryCustomer


select * from PermanantCustomer
intersect
select * from TemporaryCustomer

--no of columns and datatype must be same in both Intersect and Except
--not allowed
--First Query 2 column and second query 3 column

select CustomerId,Name from PermanantCustomer
intersect
select CustomerId,Name,country from TemporaryCustomer

--not allowed
--First Query CustomerId=int type column and second Name= varchar type column

select CustomerId,Name,country from PermanantCustomer
intersect
select Name,CustomerId,country from TemporaryCustomer

--Allowed
select CustomerId,Name,country from PermanantCustomer
intersect
select CustomerId,Name,country from TemporaryCustomer


--Except
--select * from PermanantCustomer
--select * from TemporaryCustomer

--Except returns any distinct values from the left query not found on the right query.

select * from PermanantCustomer
Except
select * from TemporaryCustomer

---Using column values and order by diffrent column
select CustomerId,Name,Country from PermanantCustomer
Except
select CustomerId,Name,Country from TemporaryCustomer
order by name desc

Regards,
Sql Query for jobs
#https://www.youtube.com/@SqlQueryforjobs



#sql #mysql #thisisqld #sqlserver #sqlab #nosql #postgresql #whitsundaysqld #jsuisqlf #northlakesqld #pacosqlos #redlandsqld #esql #gatosqls #sqlinjection #sqlimer #pacosqls #mssql #southerndownsqld #igersqld #sqldeveloper #plsql #batsqld #sqlite #nswvsqld #cmcrocksqld #nationalparksqld #pacosql #bestplacesqld #sqlsaturday #holtyspicsqld #cairnsqld #sqlmiami #mysqli #phpmysql #unicefmasqla #sqlife #smallbusinessqld #personalisedplatesqld #oldsql
#sql #python #java #javascript #programming #html #database #sqlserver #css #php #coding #developer #programmer #software #datascience #mysql #o #webdeveloper #machinelearning #code #audiomobil #sqldeveloper #spl #computerscience #sq #oracle #webdevelopment #data #dataanalytics #linux
#technology #computer #development #bigdata #backend #programador #coder #codinglife #caraudio #microsoft #csharp #sqldatabase #softwaredeveloper #informationtechnology #tecnologia #mongodb #powerbi #developers #c #it #worldcode #ti #web #programminglife #softwaredevelopment #artificialintelligence #ai #cienciadacomputacao #angular #programmerslife
stored procedures,stored procedures sql,stored procedure,sql stored procedures,what is a stored procedure,stored proc sql,how to use a stored procedure,stored proc,sql server,sql stored proc,alex the analyst,data analyst career,data analyst,data analytics,database
stored procedure in sql server,
create a stored procedure in sql server management studio,
stored procedure in sql server javatpoint,
stored procedure in sql server optimization,
stored procedure in sql server practice,
stored procedure in sql server syntax,
Difference between Stored procedures and Functions