UNCC issues¶

• Table of contents
• UNCC issues
  • Some accession numbers appear more than once, referring to different organisms

Some accession numbers appear more than once, referring to different organisms¶

Rows affected: 28 (14 distinct accession numbers)

Sample rows:

Query:

SELECT accession, count, row_num, "SciName", collector, collmonth, collday, collyear, country, state, county, locality
FROM
(
    SELECT accession, count(*) AS count
    FROM "UNCC".specimens
    GROUP BY accession
    HAVING count(*) > 1
)
accession_numbers
JOIN "UNCC".specimens USING (accession)