Difference between revisions of "MySQL/scripts"

Revision as of 07:50, 8 July 2007

• Find duplicate entries

SELECT accession,count(*) AS n
FROM mydb
WHERE kingdom!='Bacteria'
GROUP BY accession HAVING n>2;