Re: Group By Questions..

From: Jacqui Caren <Jacqui.Caren_at_ig.co.uk>
Date: Tue, 12 Oct 1999 15:03:50 GMT
Message-ID: <FJHwIF.B3L@ig.co.uk>

In article <37F591AC.C3AEDB8A_at_ntsource.com>, Frank Hubeny <fhubeny_at_ntsource.com> wrote:
>The order of the columns in the group by clause does affect the final result
>because a sort is performed on the columns in the group by clause based upon
>their order in the clause.

And when you add an order by clause this effect dissapears?

Jacqui

--
Paul Ingram Group Ltd,140A High Street,Godalming GU7 1AB United Kingdom Email: J.Caren_at_ig.co.uk Fax: +44 1483 862801 Phone: +44 1483 862800 A rather special Perl vacancy :-) http://www.ig.co.uk/about/jobs.html Use SmartCards in e-commerce systems? http://www.smartaxis.com/ Received on Tue Oct 12 1999 - 10:03:50 CDT