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

Home -> Community -> Usenet -> c.d.o.server -> group by default order

group by default order

From: <hkongogo_at_gmail.com>
Date: 22 Jun 2005 02:59:35 -0700
Message-ID: <1119434375.315954.108250@o13g2000cwo.googlegroups.com>


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 Received on Wed Jun 22 2005 - 04:59:35 CDT

Original text of this message

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