Identify Duplicate Records in Employees Table

Question

Find duplicate employee records based on email.

Accepted Answer

```sql
SELECT email, COUNT(*)
FROM employees
GROUP BY email
HAVING COUNT(*) > 1;
```

This query groups the "employees" table by the "email" column and returns only those email addresses that appear more than once, effectively identifying the duplicate records.