SELECT type, sum(price) FROM products GROUP BY type ORDER BY type
> I take it the Computer SQL Function is not support by MySQL and if not is
> there a substitute for it?
>
> If you are unfamiliar with the command it works like this:
>
> SELECT type, price
> FROM products
> ORDER BY type
> COMPUTE SUM(price)
>
> You will get a summary of prices by type in your results.
---------------------------------------------------------------------
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
