Difference Operation

Symmetric Difference Set Operation - YouTube

• Remove from one table the rows also
listed in a second table (remove from
Table1 any rows also in Table2)
• Syntax: Table1
– Table2
• Example:
Nations
– At60orAbove
Nations – (Select Latitude >= 60 AND
N_S=‘N’ From Nations
)
Creates a table with all Nations rows except the
countries above 60 N latitude