Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL
Ian Gilfillan from the MariaDB Foundation looks at the differences between the UNION, INTERSECT and EXCEPT set operators, including DISTINCT AND ALL.
提供中文字幕 Sous-titres français disponibles. Subtítulos en español disponibles. Русские субтитры. Legendas em português disponíveis. 日本語字幕あり
0:00 Intro
0:45 The sample table and data
1:16 The left and right queries
1:48 UNION
2:48 UNION ALL
3:16 INTERSECT
3:59 INTERSECT ALL
4:20 EXCEPT
5:00 EXCEPT ALL
Knowledge Base links:
* UNION (https://mariadb.com/kb/en/union/)
* INTERSECT (https://mariadb.com/kb/en/intersect/)
* EXCEPT (https://mariadb.com/kb/en/except/)
Music: "Acid Trumpet" Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 4.0 License