Re: group by and sorting

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 01 Jun 2005 00:50:12 GMT
Message-ID: <8D7ne.817$IE7.742@newssvr21.news.prodigy.com>

fitzjarrell_at_cox.net wrote:

>
> Eugene wrote:
>

>>Hi all,
>>Is there a way to "tell" Oracle not to sort when it's doing GROUP BY? I
>>think I saw something like ... group by nosort somewhere.
>>
>>Eugene

>
>
> Oracle doesn't 'sort' by default with group by, and such is noted in
> the documentation:
>

[...]
>
> David Fitzjarrell
>

More to the point, why would you want to specify "nosort" even if you could? What is the underlying problem you're trying to solve?

-Mark Bole Received on Tue May 31 2005 - 19:50:12 CDT