Learn
Set Operations
Generalizations

Congratulations! We just learned about Set Operations in SQL. What can we generalize so far?

  • The UNION clause allows us to utilize information from multiple tables in our queries.
  • The UNION ALL clause allows us to utilize information from multiple tables in our queries, including duplicate values.
  • INTERSECT is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
  • EXCEPT returns distinct rows from the first SELECT statement that aren’t output by the second SELECT statement
Folder Icon

Sign up to start coding

Already have an account?