MySQL Select Distinct Statement

0
74

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 :

The SELECT DISTINCT SQL syntax scans through entire rows and eliminates rows that have exactly the same contents in each column.

Syntax :

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:

 

 

 

Facebook Comments

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.