TIL New SQL Operators - Except, UNION, Distinct

Except Operator

The EXCEPT operator returns distinct rows from the first (left) query that are not in the output of the second (right) query

Eg: select * from table1

except

select * from table 2

Returns all elements in table1 not present in table2

UNION and Intersect Operator

In case of two queries in two tables. The Union and Intersect operator does the union and intersection of two sets.

Distinct Operator

In case of distinct operator, it returns all the unique values corresponding to a query value we want.

SELECT DISTINCT(status) FROM employee;