Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Correlated Subquery and calculated column non-functional
- From: Raymond O'Donnell <rod(at)iol(dot)ie>
- To: The Frog <mr(dot)frog(dot)to(dot)you(at)googlemail(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Correlated Subquery and calculated column non-functional
- Date: Fri, 30 Oct 2009 17:42:56 +0000
- Message-id: <4AEB25A0.30407@iol.ie> <text/plain>
On 30/10/2009 10:07, The Frog wrote: > select > product.manufacturer, > product.brand, > SUM(sales.qtysold * sales.unitprice) as turnover, > (select count(*) from cube_sales.sales as Q WHERE SUM(sales.qtysold * > sales.unitprice) > turnover) + 1 as rank You can't use the alias "turnover" in the calculation as you have - you need to use the full expression instead, or push the calculation into a subquery. BTW you're also missing a closing parenthesis from that calculation. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod(at)iol(dot)ie
- Follow-Ups:
- Re: Correlated Subquery and calculated column non-functional
- From: Richard Broersma
- Re: Correlated Subquery and calculated column non-functional
- References:
- Correlated Subquery and calculated column non-functional
- From: The Frog
- Correlated Subquery and calculated column non-functional
- Prev by Date: Re: CREATE TABLE LIKE and SERIAL
- Next by Date: Re: Correlated Subquery and calculated column non-functional
- Previous by thread: Correlated Subquery and calculated column non-functional
- Next by thread: Re: Correlated Subquery and calculated column non-functional
- Indexes: