SQL DISTINCT

When performing a query may be that there are duplicate values for some columns. For example

SELECT name FROM people

name
HARRY
WILLIAM
HARRY

If we know the different names that people are in the table, then use DISTINCT.

SELECT DISTINCT name FROM people
name
HARRY
WILLIAM