Question - How does DISTINCT work in MySQL?
Answer -
DISTINCT is used to avoid the problem of duplicity while fetching the results of a particular query. DISTINCT is used to make sure the results do not contain repeated values. DISTINCT can be used with the SELECT clause. Here is the syntax for it:
SELECT DISTINCT something FROM tablename;