ALL returns all rows, UNION removes duplicates, DISTINCT returns unique rows.

• ALL: includes all rows, even duplicates

• UNION: combines two result sets and removes duplicates

• DISTINCT: returns only unique ...read more