Skip to content

Instantly share code, notes, and snippets.

@topherPedersen

topherPedersen/count_instances.sql

Created February 21, 2020 14:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save topherPedersen/f6746616823c45ff54742e10669d1e95 to your computer and use it in GitHub Desktop.
Save topherPedersen/f6746616823c45ff54742e10669d1e95 to your computer and use it in GitHub Desktop.
Download ZIP
Count the Number of Instances a Particular Value Appears in a MySQL Table
Raw
count_instances.sql
SELECT column_with_recurring_value, count(*) as `count`
FROM my_database.my_table
GROUP BY column_with_recurring_value;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment