Re: group by default order

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 Received on Wed Jun 22 2005 - 05:11:33 CDT