Lesson 15 of 20

Merge results with UNION

Combine lists compatible with UNION, UNION ALL, INTERSECT and EXCEPT.

29 minSQL Essentials

By the end of this lesson

  • Align columns of two queries
  • Choose UNION or UNION ALL
  • Compare two sets with INTERSECT and EXCEPT

SQL Essentials

Unlock this lesson and continue the path.

Merge results with UNION is part of the complete programme: 20 lessons, 44 verifiable exercises and 2 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.