Monthly Archives: September 2011

Uncategorized

not having clause :: sql

A quick and dirty blog, cause I’m really busy.
This is simple sql for the guru’s (however, I’m not a guru!), but I recently had to find out how many records don’t exist in a table.
Its easy enough to find out how many do, using the magical count(*), but I’ve never had to do this…and if I did, it was probably a silly looking subquery.
read more »