[thelist] SQL: summing and counting the same field, based on value

Canfield, Joel JCanfield at PacAdvantage.org
Tue Jun 13 11:38:37 CDT 2006


My table has (among others) fields for type, start, and end.

I need to get the total duration for all four possible types (got that)
*and* the count where type = 9

the syntax just isn't coming to me

help?

joel



More information about the thelist mailing list