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
Cannot open any programs on Windows 7. 43
control panel does not show all installed programs 5
Keyboard typing wrong keys, opening programs! 12
Using .bat file to open file in diff location 3
program in c which finds powerful numbers 4
programs not opening 5
how to count number of palindromes in the sentence 8

Databases