Categories
General MySQL SQL Server

How to delete duplicate rows with SQL, Part 2 – Xaprb

How to delete duplicate rows with SQL, Part 2 – Xaprb

This is hard because there is no way to do this in standard SQL (correct me if I’m wrong). SQL is based on relational algebra, and duplicates cannot occur in relational algebra, because duplicates are not allowed in a set. That’s why SQL doesn’t give you tools to solve this problem.