Finding Duplicate Rows Using ROW_NUMBER() | Essential SQL
Here is a really easy way, using a window function, to find duplicate rows within a result. By using the ROW_NUMBER function we'll identify one or more duplicates within a partition, or that is, the columns we are checking for duplicates.