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.
[phone]	david@stripped