Re: The job of a relational DBMS

From: Shakespeare <>
Date: Wed, 02 Dec 2009 08:13:35 +0100
Message-ID: <4b1613a0$0$22919$>

Thomas Kellerer schreef:
> Gene Wirchenko wrote on 01.12.2009 05:35:
>>      For example, a group by in SQL forces the result to be sorted by
>> the grouping unless otherwise overridden.

> Never has been true. Group by does *not* sort the result. Not even in
> Oracle 8 and and certainly not for any Oracle version > 9 (and not for
> any Postgres as well)
> Thomas

Never? It did at least in Oracle 7. As a well known and too many times used side effect. I remember having to reprogram queries because developed programs relied on the sort....

Shakespeare Received on Wed Dec 02 2009 - 01:13:35 CST

Original text of this message