Question: why duplicate rows in sql?
Answer: How to Find Duplicate Values in a SQL Table. Generally, it's best practice to put unique constraints on a table to prevent duplicate rows. However, you may find yourself working with a database where duplicate rows have been created through human error, a bug in your application, or uncleaned data from external sources ...