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

Home -> Community -> Usenet -> c.d.o.misc -> Re: 8i vs 9i: Difference in "group by" ?

Re: 8i vs 9i: Difference in "group by" ?

From: R Chin <rchin_at_panix.com>
Date: Mon, 3 Jun 2002 16:41:20 -0400
Message-ID: <adgk2s$30c$2@reader1.panix.com>


Hi Tom, how about the DISTINCT function ? ie select distinct sale_date from sales; Can I avoid a sort here ?
thanks
Robert

>group by NEVER had to sort -- I can give you examples all of the way back
to 7.0
>whereby the group by doesn't sort.
>
>It never had it.
>It never was assured.
>
>The *only* way -- repeat -- the ONLY way to get an ordered result set is
.... to
>use ORDER BY
Received on Mon Jun 03 2002 - 15:41:20 CDT

Original text of this message

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