Find Duplicates Across A Number Of Columns

• Tweet
• 

        // description of your code here

USE reference;


SELECT surname,atitle,title,type,journal,pqid,volume, issn,issue,spage,year, 
COUNT(year) AS yc, COUNT(volume) AS vc, COUNT(spage) AS sc, COUNT(issue) AS ic, COUNT(issn) AS isc 
FROM citations 
WHERE
volume > 0
AND issue > 0
AND issn != ''
GROUP BY  spage,volume, issn,issue,year
HAVING ( ic > 1 ) AND ( vc > 1) AND ( isc > 1) AND (sc > 1) AND (yc > 1)
;

Tags:
• duplicates
• find
• group
• having
• MySQL