From: walter harms
Date: July 25 2008 3:24pm
Subject: Re: How do I (can I) use aggregate functions inside a select
List-Archive: http://lists.mysql.com/mysql/213852
Message-Id: <4889F041.6040906@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit



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 company="foo")/sum(sales)

  you can do this only when doing 2 queries and storing al least one result	

  re,
    wh