Is there any way to do the following without using subqueries or
repeating the formulas?

select city, count(id) as TotalNum, sum(Weight) as TotalWeight,
 TotalNum/TotalWeight as AvgWeight...

________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag

Reply via email to