AndroidApacheAutomation FrameworkAutomation/QTP/Selenium BlogsGoogle adsenseJava, JavaScriptquestionsSQLTechnical blogTrending

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