Re: Referencing function result inside GROUP BY?

Hi,

Vjeran Marcinko schrieb:
> Hi.
>
> Is there some way to avoid redudancy inside SQL queries like :
>
> SELECT someFunction(t.column) FROM Table t GROUP BY someFunction(t.column)
>

SELECT col FROM (SELECT someFunction(t.column) col FROM Table t) GROUP BY col

hth

Matthias Received on Mon Sep 19 2005 - 15:37:17 CDT