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. E.g SELECT States FROM Customers;E.g SELECT DISTINCT States FROM Customers; Summary of SQL – Please click here