Answers for "grouping in sql query"

grouping sql

SELECT SalesQuota, SUM(SalesYTD) 'TotalSalesYTD', GROUPING(SalesQuota) AS 'Grouping'  
FROM Sales.SalesPerson  
GROUP BY SalesQuota WITH ROLLUP;  
GO

Posted by: Guest on January-23-2021

Code answers related to "grouping in sql query"