The following query: SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY GROUPING SETS (([Name]), ([Year]))

Is equivalent with?

Question

The following query: SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY GROUPING SETS (([Name]), ([Year]))  
 
 Is equivalent with?

Answer

SELECT [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT NULL AS [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

Answer

SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Orders] GROUP BY [Year];

Answer

SELECT [Name], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

Answer

SELECT [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT NULL AS [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

Crowdly

The following query: SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GR...

Want instant access to all verified answers on moodle.astanait.edu.kz?