Posted by David Portas on 10/23/06 13:51

rcamarda wrote:
> Does the order of columns make a difference in the GROUP BY?
> Woulde GROUP BY A, B, C
> return different results than
> GROUP BY C,A,B ?

In SQL Server 200x I can only think of one instance where it does make
a difference. If you use the ROLLUP clause then the values will get
summarized based on the order specified in the GROUP BY. This means
you'll see an entirely different set of totals depending on the GROUP
BY order.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: Enterprise Manager takes 10+ min to open
• Prev in forum: Re: Order of GROUP BY - does it matter?
• Thread view: Re: Order of GROUP BY - does it matter?

[Reply to this message]