| Subject | Re: [firebird-support] Things that works in versio 1.5 and dont works in 2.0 |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-11-28T11:47:50Z |
Marco Castroo wrote:
column aliases for any aggregate functions used in the select list?
Dmitry
>Could you please show us the entire query? Could "Price" or "Mode" be
> In FireBird 1.5 I have a query with a group like this
>
> ...
> Group by ae.Author, l.Book, Price,
> case
> When op.StockChange in (23,24) Then 21
> When op.StockChange in (43,44) Then 22
> Else Mode end
> ...
column aliases for any aggregate functions used in the select list?
Dmitry