How to avoid duplicate records in SQL: select query

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

Any more programming questions? Check out our forum!