Multiple counts in sql?

nel

hello,

anyone know how you do multiple counts in one sql statement?

TechJunky

use a select within a select statement.

IE: whatever,(select count(*)
from Table tablename
where whatever = whatever1
and yever='C') as "Count of C"
select count(*)

repeat same process.....