Skip to content

Instantly share code, notes, and snippets.

@sbesson

sbesson/annotation_queries.sql

Last active May 6, 2016 09:45
Show Gist options
  • Save sbesson/b8b79ca77c0a582e1650c4676fe0718b to your computer and use it in GitHub Desktop.
Save sbesson/b8b79ca77c0a582e1650c4676fe0718b to your computer and use it in GitHub Desktop.
Download ZIP
A gist listing SQL queries to be run against production DBs to assess the criteria of https://github.com/openmicroscopy/openmicroscopy/pull/4608
Raw
annotation_queries.sql
SELECT ns, discriminator, count(*) from annotation group by ns, discriminator;
SELECT ns, discriminator, count(*) from annotation where ns = '' group by ns, discriminator;
SELECT ns, discriminator, count(*) from annotation where ns is null group by ns, discriminator;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment