At 02:33 PM 4/23/01 -0700, elias wrote:
>how can i get an SQL statment that when run, i get a query result like that:
>
>Id: Value count:
>--- --
>a4 values
>b4 values
>c2 values
SELECT ID,COUNT(*) FROM table_name GROUP BY ID;
>i feel that it's easy...but i'm not re
that would be:
select Id, count(*) from sometable group by Id
Sigitas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:
--- --
a4 values
b4 values
c2 values
i feel that it's easy...but
3 matches
Mail list logo
