SELECT - GROUP BY- Transact-SQL

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql

  • GROUP BY ROLLUP
  • GROUP BY CUBE ( )
  • GROUP BY GROUPING SETS ( )

GROUP BY (Transact-SQL)

https://technet.microsoft.com/en-us/library/ms177673(v=sql.110).aspx