INTERSECT

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.