What is 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 Related