Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 8i vs 9i: Difference in "group by" ?
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