Getting multiple dynamic counts on a single column
Posted: Fri Aug 03, 2007 2:43 pm
Is there some method to return a single row with multiple COUNTS on single column based on different values matching that column?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
SELECT
( SELECT COUNT(*) FROM tbl WHERE something=something) as myFirstCount,
( SELECT COUNT(*) FROM tbl WHERE something=somethingelse) as mySecondCount