Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Problem with the group statement...

Re: Problem with the group statement...

From: GoranG <no_at_spam.net>
Date: Fri, 19 Jul 2002 10:28:13 +0200
Message-ID: <svifju0uo9elu1vog5pbqd296c77hqtsg2@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 - 03:28:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US