Answers for "grouping set in sql"

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 set in sql"