Hello Guys! This tutorial is all about MySQL Select Distinct Statement I will tell you and teach you what is MySQL Select Distinct Statement all about, So let’s get Started:
SELECT DISTINCT returns only distinct (different) values. SELECT DISTINCTeliminates duplicate records from the results. DISTINCT can be used with aggregates: COUNT, AVG, MAX, etc. DISTINCT operates on a single column.DISTINCT for multiple columns is not supported.
The SELECT DISTINCT statement is used to return only distinct (different) values.
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
The DISTINCT clause can only be used with select statements.
The DISTINCT Clause cans through the values of the column/s specified only unique values from among-st them.
Syntax :
SELECT DISTINCT ColumnName1,ColumnName2 from TableName;
The SELECT DISTINCT SQL syntax scans through entire rows and eliminates rows that have exactly the same contents in each column.
Syntax :
SELECT DISTINCT * from TableName;
That’s it! and you’re done.
If you have any comments suggestions about MySQL Select Distinct Statement Please message us directly:
Please don’t forget to share this article to your friend and Continue to Support Itsourcecode.com
Other Articles you might read also: