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