Can anyone tell me what does distinct function do in SQL

Answer 1

The SELECT DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.

Answer 2

It clearly says that the Distinct keyword only fetches the unique values.

https://www.sololearn.com/learn/SQL/1853/

Answer 3

Thanks everyone

Answer 4

Avoid putting duplicates.