Question: what is the difference between select and select distinct?
Answer: What is the difference between select and select distinct. SELECT DISTINCT statement is used for returning only distinct (different) values from a column. SELECT statement is used for returning all the values in the table column.