Re: group by default order

On Wed, 22 Jun 2005 12:11:33 +0200, "Robert Klemme" <bob.news_at_gmx.net> wrote:

>hkongogo_at_gmail.com wrote:
>> given a table
>>
>> create table product
>> (
>> product_id integer primary key,
>> category varchar2(100),
>> sale_count integer
>> )
>>
>> what would be the order of
>>
>> select category, sum(sale_count) from product group by category;
>>
>> seems the order in 8i and 9i are different
>
>IMHO without an ORDER BY the db is free to return in whatever order it
>wants to.
>
>Kind regards
>
> robert

correct. If you want the data ORDERED do not rely on the GROUP BY

--
Sybrand Bakker, Senior Oracle DBA