How to Find Duplicate Rows in SQL Server

Last updated July 25, 2026 · By the SaturnSQL team

GROUP BY the columns that define a duplicate and keep groups with HAVING COUNT(*) > 1. Join the result back to the table to see the full duplicate rows.

SELECT email, COUNT(*) AS dupes
FROM customers
GROUP BY email
HAVING COUNT(*) > 1;

SELECT c.*
FROM customers c
JOIN (
  SELECT email
  FROM customers
  GROUP BY email
  HAVING COUNT(*) > 1
) d ON d.email = c.email
ORDER BY c.email, c.id;