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;