Re: Correlated Subquery and calculated column non-functional

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@iol.ie