RE: [sqlite] Can I refer to a column alias in same SQL Select statement?

5 1:55 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Can I refer to a column alias in same SQL > Select statement? > > Is there any way to do the following without using subqueries or > repeating the formulas? > > select city, count(id) as TotalNum, sum(Weight) as Tot

[sqlite] Can I refer to a column alias in same SQL Select statement?

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