Re: Percentage...
| From: | JJ Harrison | Date: | Mon, 29 Jul 2002 10:03:15 +0000 |
| Subject: | Re: Percentage... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20854@lists.php.net to get a copy of this message | ||
Plz ignore this. found it after more searching...
--
JJ Harrison
webmaster@tececo.com
www.tececo.com
"Jj Harrison" <webmaster@tececo.com> wrote in message
news:20020729092720.92473.qmail@pb1.pair.com...
> How, using the group by and where statments can I return the percentage of
> something?
>
> ie:
>
> pid | oid | uid |
> 1 |2 |1
> 1 |2 |1
> 1 |2 |1
> 1 |1 |1
>
> would return
> oid | percent
> 2 | 75
> 1 | 25
>
> Thx,
>
>
> --
> JJ Harrison
> webmaster@tececo.com
> www.tececo.com
>
>
>