Menu

SQL - Avoid duplicates in the result of a SELECT query

SQL - Avoid duplicates in the result of a SELECT query

MySQL - Evitar los duplicados en un SELECT

MySQL - Éviter les doublons dans un SELECT

SQL - Evitare i doppioni in SELECT

MySQL - evitar as duplicatas em um SELECT

MySQL- jak uniknąć duplikatów w SELECT?

Issue
Solution

Issue

How to avoid duplicates in the results of a SQL query?

Solution

Simply use the DISTINCT clause and between the SELECT clause and the fields.
Example:

SELECT distinct id,name,surname FROM mytable

More informations available on this : Link

Related

Published by jak58. Latest update on October 18, 2013 at 10:25 AM by deri58.

Error connecting to SQL Server 2005

Error connecting to SQL Server 2005