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
sound device 27
VBA code to open non excel programs 10
attrib command in win 7 18
control panel does not show all installed programs 5
c++ program computing sum of squares of two 1
circle movement in turbo c 12
Using .bat file to open file in diff location 3
Cannot open any programs on Windows 7. 43
Around the same subject