What are the maximum number of Columns in GROUP BY clause in SQL Server?
Posted on : 16-04-2012 | By : Devi Prasad | In : SQL Server Basics
0
What are the maximum number of Columns in GROUP BY clause in SQL Server?
The maximum number of Columns in GROUP BY clause are limited only by number of bytes.
Below link gives details regarding maximum bytes per Group By Clause.
What are the maximum Bytes per GROUP BY in SQL Server?
What are the maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server?
The maximum number of Columns or expressions in GROUP BY WITH CUBE is 10 .
What are the maximum number of Columns or expressions in GROUP BY WITH ROLLUP in SQL Server?
The maximum number of Columns or expressions in GROUP BY WITH ROLLUP is 10 .
| Max Capacity For | SQL Server 2012 | SQL Server 2008 R2 | SQL Server 2008 | SQL Server 2005 |
|---|---|---|---|---|
| maximum number of Columns in GROUP BY clause in SQL Server | Limited only by number of bytes. | Limited only by number of bytes. | Limited only by number of bytes. | Limited only by number of bytes. |
| Maximum number of Columns or expressions in GROUP BY WITH CUBE | 10 | 10 | 10 | 10 |
| Maximum number of Columns or expressions in GROUP BY WITH ROLLUP | 10 | 10 | 10 | 10 |
http://msdn.microsoft.com/en-us/library/ms143432.aspx
Reference : Devi Prasad (sqlserverlearner.com)
Do you like my blog?
If you liked reading this blog, please help spread the word by sharing this blog with your friends.
Need Help On SQL Server?
Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.
Tags: max number of Columns in GROUP BY clause in SQL Server, maximum number of Columns in GROUP BY clause in SQL Server, maximum number of Columns in GROUP BY clause in SQL Server 2005, maximum number of Columns in GROUP BY clause in SQL Server 2008, maximum number of Columns in GROUP BY clause in SQL Server 2008 r2, maximum number of Columns in GROUP BY clause in SQL Server 2012, maximum number of Columns in GROUP BY WITH CUBE in SQL Server, maximum number of Columns or expressions in GROUP BY WITH CUBE, maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server, maximum number of expressions in GROUP BY WITH CUBE in SQL Server, What are the maximum number of Columns in GROUP BY clause in SQL Server 2005, What are the maximum number of Columns in GROUP BY clause in SQL Server 2008, What are the maximum number of Columns in GROUP BY clause in SQL Server 2008 r2, What are the maximum number of Columns in GROUP BY clause in SQL Server 2012, What are the maximum number of Columns in GROUP BY WITH CUBE in SQL Server, What are the maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server 2005, What are the maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server 2008, What are the maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server 2008 r2, What are the maximum number of Columns or expressions in GROUP BY WITH CUBE in SQL Server 2012, What are the maximum number of expressions in GROUP BY WITH CUBE in SQL Server
