Thread: How do i Find Duplicate Data
View Single Post
  #2 (permalink)  
Old 2006-07-20, 01:45 AM
vladimir_cz vladimir_cz is offline
Senior Member
  
Join Date: Jul 2006
Location: Prague, Czech Republic
Posts: 193
vladimir_cz is on a distinguished road
Send a message via ICQ to vladimir_cz Send a message via MSN to vladimir_cz Send a message via Yahoo to vladimir_cz Send a message via Skype™ to vladimir_cz
Default
select id, count(id) as idc from products group by id order by idc desc - you got a list with two columns, 1st - ID, 2nd - counter for ID (duplicates)
__________________
Thank you. Vladimir, Czech Republic.
http://www.smartwebco.com/
I'm looking for job.
Reply With Quote