task #7891
Updated by Andreas Kohlbecker over 5 years ago
The phycobank db contains 117 cases of potentially duplicate names which need to be checked. See attached spreadsheet
17 of these cases are names which are empty.
Duplicate names can be found by
~~~sql
SELECT COUNT(*), genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet
FROM TaxonName
GROUP BY genusOrUninomial, infraGenericEpithet, specificEpithet, infraSpecificEpithet
HAVING COUNT(*)>1;
~~~