Re: Problem with the group statement...
From: GoranG <no_at_spam.net>
Date: Thu, 18 Jul 2002 15:43:40 +0200
Message-ID: <cbhdju08qdliltg95l5oqisqu4vo7tbhks_at_4ax.com>
Date: Thu, 18 Jul 2002 15:43:40 +0200
Message-ID: <cbhdju08qdliltg95l5oqisqu4vo7tbhks_at_4ax.com>
On Thu, 18 Jul 2002 13:12:39 +0200, "Volker Hetzer"
<volker.hetzer_at_ieee.org> wrote:
>
>"Lennart Jonsson" <lennart_at_kommunicera.umea.se> wrote in message news:6dae7e65.0207170906.5d1c6712_at_posting.google.com...
>> [Good explanation of grouping]
>> the order by is applied last
>So the result of the group clause is sorted.
>
>Lots of thanks!
>Volker
Hhmm, not sure about that.
I don't think so, but still check the reference(s) - I think that sorting occurs before grouping. This is neccessary for First() and Last() aggregate functions to work properly. Still I have not used First and Last for a whiiiile.
Anybody knows what does the standard say?
( GoranG79 AT hotmail.com ) Received on Thu Jul 18 2002 - 15:43:40 CEST