MySql / sql help plz!
| From: | elias | Date: | Mon, 23 Apr 2001 21:33:44 +0000 |
| Subject: | MySql / sql help plz! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49832@lists.php.net to get a copy of this message | ||
i have this table:
---------------------
Id Value
-- ------
a a
a b
a c
a d
b a
b b
b c
b d
c a
c b
how can i get an SQL statment that when run, i get a query result like that:
Id: Value count:
--- --------------
a 4 values
b 4 values
c 2 values
i feel that it's easy...but i'm not really good at SQL.
-elias
http://eassoft.cjb.net