Columns other than id can contain duplicate values but, at times, we only want to retrieve the different, or distinct, values.

Did you notice the duplicate values in the age column of the family table?

Great! The DISTINCT keyword, which we can use in a SELECT clause, only selects the distinct values in the age column and skips the duplicate  12.

Didn't we want to retrieve distinct values?