[RBASE-L] - Re: FAIL: SELECT (expression) AS alias

[Bill Downall]

Bruce,

You cannot "group by" a column that is used in an aggregate function
(count, sum, min, max, avg). Turtle cannot be both after select and also
the column in the count expression.

Maybe you want something like:

SELECT Turtle, COUNT(*) AS Stack +
FROM Salamasond +
WHERE KingOfThemAll LIKE 'Yertle' +
GROUP BY Turtle +
HAVING COUNT(*) > 10 +
ORDER BY Turtle
 On Jun 9, 2013 9:50 PM, "Bruce A. Chitiea" <rby...@safesectors.com> wrote:

> All:
>
> I would like to 'ALIAS' an expression in a SELECT statement:
>
> SELECT Turtle, COUNT(Turtle) AS Stack +
> FROM Salamasond +
> WHERE KingOfThemAll LIKE 'Yertle' +
> GROUP BY Turtle,Stack +
> HAVING Stack > 10 +
> ORDER BY Stack,Turtle
>
> ... or column names to that effect, but what I get is an:
>
> -ERROR- Column stack not found (2369)
>
> Is there a way to 'package' the expression to have Mack's 'stack'
> recognized?
>
> Thanks
>
> Bruce Chitiea
> SafeSectors, Inc.
> eCondoMetrics
>
>
>