How to find duplicate records in a table on database - SQL tips select name, count(name) as times from...

Please Visit: http://ift.tt/1ajReyV

How to find duplicate records in a table on database - SQL tips

select name, count(name) as times from

contacts group by name, phone having times>1;

http://ift.tt/1qPijVe

http://ift.tt/1qPihNp

How to find duplicate records in a table on database - SQL tips

from Public RSS-Feed of Jeffery yuan. Created with the PIXELMECHANICS 'GPlusRSS-Webtool' at http://gplusrss.com http://ift.tt/1rgbvmf

via LifeLong Community