467,879 Members | 1,335 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,879 developers. It's quick & easy.

Duplicate Entries

I have a table with duplicated entries. How could i return the single rows of each record so i can get rid of the duplicates. Or how do i remove duplicate entry rows ?
Feb 20 '09 #1
  • viewed: 1145
2 Replies
It all depends what you mean by duplicate
If you mean that there are several - but not all - columns that hold duplicate values, then you can use the non duplicate columns to uniquely identify the rows that you want to delete
However - if you have 2 or more rows with exactly the same content, then there is no way to distinguish between them, your only solution there is to store the values, delete all the rows with those values and then reinsert the row.
Feb 20 '09 #2
Expert 2GB
Or you can use DISTINCT keyword on your select.

Here's the complete syntax.

-- CK
Feb 20 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Gary Lundquest | last post: by
1 post views Thread by Gary Lundquest | last post: by
1 post views Thread by marx | last post: by
3 posts views Thread by andreas.maurer1971 | last post: by
4 posts views Thread by sri2097 | last post: by
5 posts views Thread by Chris Lasher | last post: by
6 posts views Thread by teser3 | last post: by
7 posts views Thread by php_mysql_beginer911 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.