Is there a quick way to do counts on multiple columns
From: Owen <brandonfair_at_hotmail.com>
Date: 21 Nov 2001 15:45:52 -0800
Message-ID: <20e5d4a1.0111211545.3a95e60b_at_posting.google.com>
Date: 21 Nov 2001 15:45:52 -0800
Message-ID: <20e5d4a1.0111211545.3a95e60b_at_posting.google.com>
if have some code that is something like
Is there a way to combine these all into one statement?
Thanks for any help
Owen
SELECT COUNT(*) FROM aTable for COL1 ="R";
SELECT COUNT(*) FROM aTable for COL2 ="R";
SELECT COUNT(*) FROM aTable for COL3 ="A";
SELECT COUNT(*) FROM aTable for COL4 ="B";