How to avoid duplicate records in SQL: select query

Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how.

To avoid duplicate results:

• 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 to the MySQL website.