Find duplicate business keys

sql

SELECT email, COUNT(*) AS duplicate_count
FROM users
GROUP BY email
HAVING COUNT(*) > 1;

Explanation

This query is often the first step before cleanup and adding a unique constraint.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Data Quality and Maintenance Queries

Detect child rows missing a valid parent.

Open In sheetsqlsame section

Keep one row per key and delete the extras.

Open In sheetsqlsame section

Inspect the execution plan for a SELECT statement.

Speed up frequent equality or range predicates.

Paginate by a stable cursor instead of a large OFFSET.

Run a query and collect timing or actual row information where supported.