select columnA,
columnB,
count(*)
from table_name
group by columnA,
columnB
having count(*) > 1
Being a complete non programmer, i thought it would be a good idea to help others like me who have no programming knowledge but want to develop web based applications. Additionally i wanted to be able to access all these for my own repetitive use.
Sunday, April 28, 2013
how to find duplicates in two columns of mysql database table
any one column can have duplicates. but both columns together are unique. this is how you find duplicates
Subscribe to:
Posts (Atom)