Re: Group By Questions..

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/