Mysql

MySQL SELECT DISTINCT

A table could hold duplicate rows. In such a case, to view only unique rows the distinct clause can be used. The DISTINCT clause allows removing duplicates from the result set. 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 amongst 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;

Recommended Tutorials for you


Related posts

MySQL PHP Connections

Anuj Kumar

MySQL Database and Tables

Anuj Kumar

MySQL Altering tables

Anuj Kumar

How to Connect PHP with MySQL Database

Anuj Kumar

MySQL Select Query

Anuj Kumar

MySQLi Procedural Functions

Anuj Kumar

MySQL Data Type

Anuj Kumar

MySQL Users

Anuj Kumar

MySQL Command-line

Anuj Kumar

Leave a Comment

* By using this form you agree with the storage and handling of your data by this website.

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