"Group By *" in a SQL Server 2008 query?

Question

I have a large list of columns in a Select.

To group the result I have to get all the items in the select clause and put in the Group By clause.

I wonder if there's any easy way to get all the items there for reference in GROUP BY, such as a GROUP BY *

How can this be done?

Answer 1

The "easy" way is to copy/paste the columns from your SELECT into the GROUP BY. There's no syntactic short cut in SQL for this.