04pallav
9/13/2017 - 9:54 PM

EXCEPT

EXCEPT

#The SQL EXCEPT clause/operator is used to combine two SELECT statements 
#and returns rows from the first SELECT statement that are not returned by 
#the second SELECT statement.

SELECT DISTINCT MAKER FROM PRODUCT WHERE TYPE='PC'
EXCEPT 
SELECT DISTINCT MAKER FROM PRODUCT WHERE TYPE='LAPTOP'