SQL difference between SELECT and SELECT DISTINCT

• SELECT retrieves all rows from a table, while SELECT DISTINCT retrieves only unique rows

• SELECT may return duplicate rows, while SELECT DISTINCT elimina...read more