Re: Referencing function result inside GROUP BY?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 19 Sep 2005 14:02:50 +0200
Message-ID: <432ea8e3$0$9454$626a14ce@news.free.fr>

"Vjeran Marcinko" <netko_at_nesto.com> a écrit dans le message de news: dgltfn$t2o$1_at_sunce.iskon.hr...
| Hi.
|
| Is there some way to avoid redudancy inside SQL queries like :
|
| SELECT someFunction(t.column) FROM Table t GROUP BY someFunction(t.column)
|
| with something like:
|
| SELECT someFunction(t.column) AS result FROM Table t GROUP BY result
|
| Later gives me "invalid column name: result" error :-(
|
|
| -Vjeran
|
|

select DISTINCT someFunction(t.column) FROM Table t; select UNIQUE someFunction(t.column) FROM Table t;

Regards
Michel Cadot Received on Mon Sep 19 2005 - 07:02:50 CDT