Question: what is the difference between minus and intersect in sql?
Answer: INTERSECT is opposite from MINUS as it returns us the results that are both to be found in first and second SELECT statement. There is an interesting example that us use SET OPERATORS to compare whether two tables have identical values, testing symetric difference.