Chris So
Nov 26, 2020

--

Why the outer query?

With GROUP BY and HAVING COUNT(*) >= 2 your result set should already show the duplicates, if present.

The self-join makes it more complicated to read and requires more resources.

--

--

Chris So
Chris So

Written by Chris So

Data Dude and SQL enthusiast. Occasionally does Pixel art◾

Responses (1)