Tag Archive for "tagging"

Finding Frequency Counts With SQL

January 11th, 2008 by Andrew

Finding the frequency of items in a database table is something I find myself needing to do a lot. Though for some reason when I need to do this, I always forget how, so here it is. Let’s say you have a table of tag data with two columns and a bunch of rows. Let’s say the table is a simple adjacency list of tags for posts on a blog.

Continue Reading Finding Frequency Counts With SQL...