this doesnt work as i need either :o(
it returns 3 rows, each with a count of 3 inside. i just want to get a
*single row* with the number 3 in it (for my example).
:o(
thanks for trying though...
----- Original Message -----
From: "Lezz Giles" <[EMAIL PROTECTED]>
To: "Jamie Burns" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 2:29 PM
Subject: Re: surely an easy quick one
> I haven't tested this; I'm not an SQL guru. I just
> like a challenge :-)
>
> SELECT COUNT(*) FROM table WHERE team = "support" GROUP BY name;
>
> Lezz Giles
>
> ----- Original Message -----
> From: "Jamie Burns" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, September 14, 2001 9:08 AM
> Subject: surely an easy quick one
>
>
> > Hello again :o)
> >
> > This is surely an easy quick one but my brain wont work!
> >
> > I have a table (ref, name, team, seminar_ref) like:
> >
> > 1 bill support 100
> > 2 bill support 101
> > 3 bill support 102
> > 4 ben development 201
> > 5 ben development 103
> > 6 ben development 204
> > 7 bob support 104
> > 8 bob support 102
> > 9 bob support 107
> > 7 pat support 102
> > 8 pat support 202
> > 9 pat support 105
> >
> > I need to get a count of how many individual people are in the table,
that
> > belong to a certain group. So if I wanted to find all individual people
in
> > support the answer in this case it would be 3 (bill, bob and pat). I
dont
> > need their names, just the count.
> >
> > Thanks,
> >
> > Jamie.
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
