Apr 172008
Saw this blog piece over at Conor Cunningham’s Blog and wanted to point to it, because I never knew this behaviour.
SELECT COUNT(*) returns the number of rows in a table, but when you do SELECT COUNT(<Column>) it will return the non-null number of rows. Nifty – but behaviour which is immensely important to actually know.
