Plz ignore this. found it after more searching...

--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com

"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
> [EMAIL PROTECTED]
> www.tececo.com
>
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to