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;

1	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;

1	SELECT DISTINCT * from TableName;

Tags: How to select distinct values in SQL MySQL Distinct mysql select MySQL SELECT DISTINCT SQL SELECT DISTINCT

Anuj Kumar

Hi! I am Anuj Kumar, a professional web developer with 5+ years of experience in this sector. I found PHPGurukul in September 2015. My keen interest in technology and sharing knowledge with others became the main reason for starting PHPGurukul. My basic aim is to offer all web development tutorials like PHP, PDO, jQuery, PHP oops, MySQL, etc. Apart from the tutorials, we also offer you PHP Projects, and we have around 100+ PHP Projects for you.