In your original message, you said "You will get a summary of prices by type
in your results." and that is what my query gives you. It returns the sum of
the price columns from any rows that are eliminated by the GROUP BY clause.
What do you want it to return?
> Please strike previous message the
: Chris Bolt; [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported
Okay I may have been a bit vague on my description.
Is there something similar for compute?
-Original Message-
From: Chris Bolt [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED
: Monday, May 21, 2001 1:07 PM
To: [EMAIL PROTECTED]
Subject: RE: Compute SQL Function Not Supported
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 ar
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
> COMP
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.