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!
Subject Replies
All my icons change to Internet Explorer 41
C program to print 1 11111 1111 1
VBA code to open non excel programs 10
attrib command in win 7 18
sound device 27
c++ program computing sum of squares of two 1
control panel does not show all installed programs 5
circle movement in turbo c 12
Cannot open any programs on Windows 7. 43
What is the difference between run and execution. 7
Around the same subject