MySQL/scripts

From Christoph's Personal Wiki
Revision as of 07:50, 8 July 2007 by Christoph (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • Find duplicate entries
SELECT accession,count(*) AS n
FROM mydb
WHERE kingdom!='Bacteria'
GROUP BY accession HAVING n>2;
Retrieved from "http://wiki.christophchamp.com/index.php?title=MySQL/scripts&oldid=4214"