MySQL Query
| From: | Gary Robinson | Date: | Fri, 03 Nov 2000 16:07:37 +0000 |
| Subject: | MySQL Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4191@lists.php.net to get a copy of this message | ||
I need to perform a query that calculates a percentage of the total:
Type Quantity Percent of Total
Brown 50 25.00
White 25 12.50
Red 100 50.00
Blue 25 12.50
Is this possible within a query or will I need to write some code (i.e.,
PHP, etc.) to accomplish the task?
Thanks for the help, in advance!