ADQL: GROUP BY <value_expression> ?

[Walter Landry]

It also works in SQLite, but does not work in Informix.  We are moving
away from Informix, so it might not matter to us.

Cheers,
Walter Landry

Felix Stoehr <fstoehr at eso.org> wrote:
> This query seems to work also in ORACLE.
> 
> On 05/04/2016 01:25 AM, Simon Murphy wrote:
>> SELECT
>>>   (ra*6.0) AS alias_A,
>>>   (decl*6.0) AS alias_B,
>>>   COUNT(*) AS num
>>> FROM
>>>   alpha_source
>>> WHERE
>>>   (ra>0)
>>> GROUP BY
>>>    (ra*6.0),
>>>    (decl*6.0)