Question

How Many Number Of Columns A Record Group Can Have?

Answer 1

The simplest solution is to use a derived table:

Select Count(*)

From (

Select ...

From TempTable

Group By column_1, column_2, column_3, column_4

) As Z

Another solution is to use a Count Distinct:

Select ...

, ( Select Count( Distinct column_1,

column_2, column_3, column_4 )

From TempTable ) As CountOfItems

From TempTable

Group By column_1, column_2,

column_3, column_4

Hope this helps you ☺️☺️☺️