Aikesheng Open Source Community
Oct 12, 2022 · Databases
Using INTERSECT and EXCEPT in MySQL 8.0.31 and Workarounds for Earlier Versions
This article explains how MySQL 8.0.31 introduces native INTERSECT and EXCEPT set operators, demonstrates how to achieve the same intersection and difference results in MySQL 5.7 using joins, and shows usage of the ALL modifier for preserving duplicate rows.
INTERSECTMySQLSQL
0 likes · 7 min read