>-Original Message-
>From: David Ruggles [mailto:[EMAIL PROTECTED]
>Sent: Friday, July 25, 2008 10:53 AM
>To: 'mysql'
>Subject: RE: How do I (can I) use aggregate functions inside a select
>
>I get:
>Error Code : 1140
>Mixing of GROUP columns (MIN(),MAX
ineer Safe Data, Inc.
> (910) 285-7200[EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 25, 2008 10:37 AM
> To: David Ruggles
> Cc: mysql
> Subject: Re: How do I (can I) use aggregate
David Ruggles wrote:
> I may be approaching this all wrong, but I need to know a percentage of
> total sales within a select statement.
>
> So I can do something like this:
> Select company, state, sales, sum(sales) / sales as percent
> From Sales
>
>
mmh, you want
sum(sales where compan
: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2008 10:37 AM
To: David Ruggles
Cc: mysql
Subject: Re: How do I (can I) use aggregate functions inside a select
yes, u can use the below sql.
regards
anandkl
On 7/25/08, David Ruggles <[EMAIL PROTECTED]> wrote:
>
> I may be
yes, u can use the below sql.
regards
anandkl
On 7/25/08, David Ruggles <[EMAIL PROTECTED]> wrote:
>
> I may be approaching this all wrong, but I need to know a percentage of
> total sales within a select statement.
>
> So I can do something like this:
> Select company, state, sales, sum(sales)
