How would you write a SQL query to detect and handle duplicate records in a large production table without causing downtime?

Sample answer preview

Handling duplicate records in production is a task that junior DBAs encounter frequently, and it requires careful planning to avoid data loss or application disruption. The approach involves detection, analysis, and safe removal in distinct phases.