forum

Home / DeveloperSection / Forums / How to use Except in Sql server

Ask Question

How to use Except in Sql server

Anonymous User 1816 08-Mar-2016
We want to use  Except in Sql server.how to use this please help me.
database sql server  sql 
Updated on 08-Mar-2016
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

08-Mar-2016

 

EXCEPT: The EXCEPT operator returns all distinct the rows that are present in the result set of the first query, but not in the result set of the second query. It means it returns the difference between the two result sets.

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:
 
answer 415870803102734
 
ProductOrder:
 
answer 415870803102734
 
EXCEPT QUERY:
 
SELECT ProductId,ProductName,ManufacturedBy FROM ProductStock


EXCEPT


SELECT ProductId,ProductName,ManufacturedBy FROM ProductOrder
Result :
answer 415870803102734

Liked By