SQL - Avoid duplicates in the result of a SELECT query




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
Published by jak58. Latest update on October 18, 2013 at 10:25 AM by deri58.
This document, titled "SQL - Avoid duplicates in the result of a SELECT query," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Error connecting to SQL Server 2005