DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Richard has posted 22 posts at DZone. View Full User Profile

Find Duplicates Across A Number Of Columns

02.09.2006
| 340 views |
  • submit to reddit
        // 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)
;