Re: group by function

From: <dann_mich_com_at_my-deja.com>
Date: Wed, 08 Dec 1999 07:49:47 GMT
Message-ID: <82l2ir$m4n$1@nnrp1.deja.com>

How 'bout this:

SELECT Max(Temp), country
FROM
(SELECT City.ShowTemp(), City.GetCountry()) AS FakeTable(Temp, Country)
GROUP BY FakeTable.Country

Or something like that..

Dan

In article <82hle9$8sd$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> Hi
>
> I have a problem in using the group by clause
with a
> user-defined-function. Is there a way with some
'pragma' statements
> group by on a function can be made possible in
SQL? I guess, this should
> be possible, because group by on SUBSTR (
built-in function) is still
> possible.
>
> Any idea would be appreciated.
>
> Thanks &
> regards
> Nanda
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 01:49:47 CST