Why would you use a 'DISTINCT' clause in a query?

Question

1. To remove rows when some of the data in the columns is duplicated
2. To remove any null values from the report
3. To sort reports in a distinctive order
4. To prevent duplicates rows appearing on the report

Which one

Answer 1

1. To prevent duplicates rows appearing on the report