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
circle movement in turbo c 12
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
Cannot open any programs on Windows 7. 43
Keyboard typing wrong keys, opening programs! 12
Around the same subject