1--- GROUP FUNCTION | MULTI ROW FUNCTION | AGGREGATE FUNCTION
2--- COUNT , MAX , MIN , SUM , AVG
1SELECT SalesQuota, SUM(SalesYTD) 'TotalSalesYTD', GROUPING(SalesQuota) AS 'Grouping'
2FROM Sales.SalesPerson
3GROUP BY SalesQuota WITH ROLLUP;
4GO
5