What is difference between select and select distinct

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

fb-share-icon