How do I (can I) use aggregate functions inside a select

[David Ruggles]

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


Thanks,

David Ruggles
CCNA MCSE (NT) CNA A+
Network Engineer        Safe Data, Inc.
(910) 285-7200  [EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]