Re: Problem with the group statement...

From: GoranG <no_at_spam.net>
Date: Thu, 18 Jul 2002 15:43:40 +0200
Message-ID: <cbhdju08qdliltg95l5oqisqu4vo7tbhks@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 - 08:43:40 CDT