Re: Problem with the group statement...

From: GoranG <no_at_spam.net>
Date: Fri, 19 Jul 2002 10:28:13 +0200
Message-ID: <svifju0uo9elu1vog5pbqd296c77hqtsg2_at_4ax.com>

On Fri, 19 Jul 2002 01:54:18 -0400, Steve Kass <skass_at_drew.edu> wrote:
><cut>

Thank you for the explanations...

>The FIRST() and LAST() aggregate functions do not exist in the SQL-92
>standard. They are proprietary extensions.
><cut>

Just to clear up: Where this extensions does exist there DBMS ensures that sorting is applied after grouping and before actual call to aggregate functions?

( GoranG79 AT hotmail.com ) Received on Fri Jul 19 2002 - 10:28:13 CEST

This message: [ Message body ]
Next message: Ruud de Koter: "Re: Efficient query to fetch the columns in an entire relation?"
Maybe in reply to: Volker Hetzer: "Problem with the group statement..."
In reply to Steve Kass: "Re: Problem with the group statement..."
Next in thread: Ruud de Koter: "Re: Efficient query to fetch the columns in an entire relation?"
Reply: Nis Jorgensen: "Re: Problem with the group statement..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message