Re: Referencing function result inside GROUP BY?

From: Vjeran Marcinko <netko_at_nesto.com>
Date: Tue, 20 Sep 2005 07:18:20 +0200
Message-ID: <dgo62v$gqc$1@sunce.iskon.hr>

Matthias is the man!

Thanx,
Vjeran

"Matthias Kleinicke" <Matthias.Kleinicke_at_gmx.de> wrote in message news:dgn7g6$vcq$1_at_online.de...
> 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 Tue Sep 20 2005 - 00:18:20 CDT