|
-
March 6th, 2009, 12:49 PM
#1
MYSQL - Multiple count in rows instead of columns
When I execute the sql query bellow:
SELECT (SELECT count(STATE) FROM `table` WHERE STATE='MI') as E1, (SELECT count(STATE) FROM `table` WHERE STATE='ID') as E2 FROM `table`
the result is something like this:
E1 E2
12 15
One next to the other.
How could I have the results one BELLOW the other ?!!
This is what I would like:
E1 12
E2 15
Any ideas?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|