Use Intersect in sql server

Anonymous User 1905 08 Mar 2016

We want to use Intersect in sql server.how will do this please help me.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 08 Mar 2016

Intersect: The intersect statement is used to fetch the common records between the tables. Here we have two tables. Both tables have similar kinds of records.

CREATE TABLE ProductStock

(
ProductId INT PRIMARY KEY IDENTITY(1,1),

ProductName VARCHAR(100),

ManufacturedBy VARCHAR(100),

StockQty BIGINT,

LastUpdated date

)
Go
CREATE TABLE ProductOrder

(
OrderId INT PRIMARY KEY IDENTITY(1,1),

ProductId int,

ProductName VARCHAR(100),

ManufacturedBy VARCHAR(100),

OrderQty BIGINT,

OrderDate date

)

ProductStock : 
 
ProductOrder:
 
INTERSECT QUERY :
 
SELECT ProductId,ProductName,ManufacturedBy FROM ProductStock

INTERSECT
SELECT ProductId,ProductName,ManufacturedBy FROM ProductOrder

Result :

forum

Use Intersect in sql server

Can you answer this question?

1 Answers