{"id":8534,"date":"2019-01-26T12:00:06","date_gmt":"2019-01-26T12:00:06","guid":{"rendered":"https:\/\/dbtut.com\/?p=8534"},"modified":"2019-01-26T12:31:51","modified_gmt":"2019-01-26T12:31:51","slug":"grouping-sets-operator-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/","title":{"rendered":"GROUPING SETS Operator in SQL SERVER(TSQL)"},"content":{"rendered":"

\n

SQL Server supports grouping of data with GROUP BY since older versions, and also offers WITH ROLLUP and WITH CUBE operators for grand-total and sub-totals. SQL Server 2008 provides a new operator named GROUPING SETS.\u00a0With SQL Server 2008, it is recommended to use GROUPING SETS instead of WITH ROLLUP or WITH CUBE operators.<\/p>\n

You can find many detailed examples about GROUPING SETS, ROLLUP and CUBE operators in this article.<\/p>\n

And alson you can find the details of GROUP BY, WITH ROLLUP and WITH CUBE in the below articles.<\/p>\n

“Group By Clause, SUM, MAX, MIN, AVG, COUNT and COUNT_BIG Functions in SQL Server<\/a>“,<\/p>\n

“WITH ROLLUP and WITH CUBE Operators in SQL Server(TSQL)<\/a>”<\/p>\n

Also you should read the below article too.<\/p>\n

“GROUPING and GROUPING_ID Functions in SQL Server(TSQL)<\/a>”<\/p>\n

Let’s make examples for a better understanding of GROUPING SETS Operator.<\/p>\n

Example:<\/strong><\/p>\n

First, we create a table with the help of the following script and add a few records into this table.<\/p>\n

CREATE TABLE [dbo].[Sales](\n[ID] [int] NULL,\n[Location] [varchar](50) NULL,\n[Month] [varchar](50) NULL,\n[Category] [varchar](50) NULL,\n[Price] [int] NULL\n) ON [PRIMARY]\nGO\nINSERT INTO [dbo].[Sales] VALUES (1,'L1','A2','K1',100),\n(2,'L2','A2','K1',85),\n(3,'L1','A2','K1',150),\n(4,'L1','A1','K1',90),\n(5,'L1','A1','K2',80),\n(6,'L2','A1','K2',90),\n(7,'L2','A1','K1',80)\nGO\nSelect * FROM [dbo].[Sales]<\/pre>\n
\"\"<\/p>\n
This table has 3 fields that we can use as a dimension. (Location, Month and Category).<\/p>\n
We will also use the Price column as KPI \/ Numeric Indicator. Our goal is to see the sum of each dimension at the same time as below.<\/p>\n
As can be seen from the result of below query, the sum of the Month and Location data appears in the same list. To do this in SQL, it is necessary to group each field and merge it with UNION.<\/p>\n
SELECT '' AS [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Month]\nUNION ALL\nSELECT [Location], '' [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location]<\/pre>\n
\"\"<\/p>\n
In this way, when we want to include more than one dimension, we must create a UNION series for each. The GROUPING SETS clause that comes with SQL Server 2008 offers both flexibility and performance. This sentence, which is compatible with ANSI SQL 2006, can be considered as a function used with GROUP BY. As a parameter, it is enough to write the columns to be aggregated.<\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n[Location],\n[Month]\n)<\/pre>\n
\"\"<\/p>\n
Or let’s replace NULL values to get exactly the same image in our example.<\/p>\n
SELECT ISNULL([Location],'') AS Location, ISNULL([Month],'') AS Month, SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n[Location],\n[Month]\n)<\/pre>\n
\"\"<\/p>\n
Using the three dimensions in our example, let’s calculate all possibilities separately without GROUPING SETS and using GROUPING SETS.<\/p>\n
SELECT NULL AS [Location], [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Month],[Category]\nUNION ALL\nSELECT [Location], NULL [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location],[Category]\nUNION ALL\nSELECT [Location], [Month], NULL [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location],[Month]\nOrder By [Location]<\/pre>\n
SELECT [Location], [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Month], [Category]),\n([Location], [Category]),\n([Location], [Month])\n)\nOrder By [Location]<\/pre>\n
When you run the above two queries, a result returns as follows.<\/p>\n
\n
\"\"<\/p>\n
Let’s calculate the sub-total and grand-total by using the Location and Month dimensions.<\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location], [Month]\nUNION\nSELECT [Location], NULL, SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location]\nUNION\nSELECT NULL, NULL, SUM(Price) Endorsement\nFROM [dbo].[Sales]<\/pre>\n
\"\"<\/p>\n
To make it clearer, let’s sort:<\/p>\n
SELECT * FROM (\nSELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location], [Month]\nUNION\nSELECT [Location], NULL, SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location]\nUNION\nSELECT NULL, NULL, SUM(Price) Endorsement\nFROM [dbo].[Sales]\n) as T ORDER BY ISNULL([Location],'ZZZZ'), ISNULL([Month],'ZZZZ')<\/pre>\n
\"\"<\/p>\n
Instead of combining this type of process with UNION for each dimension, we do this with WITH ROLLUP or WITH CUBE. So we’ll get the same result with an easier typing.<\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location], [Month]\nWITH ROLLUP<\/pre>\n
\"\"<\/p>\n
To get the same result as GROUPING SETS, we need to write the fields to be aggregated.<\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month]),\n[Location],\n()\n)<\/pre>\n
\"\"<\/p>\n
As you can see, there is flexibility in the GROUPING SETS method. WITH ROLLUP automatically creates a grand total for all fields grouped, while GROUPING SETS creates only for what we do. For example, if you do not want to calculate the grand total, simply remove the line “()” in GROUPING SETS.<\/p>\n
GROUPING SETS without Grand Total:<\/strong><\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month]),\n[Location]\n)<\/pre>\n
\"\"<\/p>\n
GROUPING SETS without Sub Total and Grand Total:<\/strong><\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month])\n)<\/pre>\n
\"\"<\/p>\n
GROUPING SETS with only Grand Total:<\/strong><\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month]),\n()\n)<\/pre>\n
\"\"<\/p>\n
Let’s add the “Month” field to GROUPING SETS. Thus, all possible aggregated rows will be created for Location and Month fields. We were doing this with WITH CUBE.<\/p>\n
WITH CUBE Method:<\/strong><\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY [Location], [Month]\nWITH CUBE<\/pre>\n
\"\"<\/p>\n
WITH GROUPING SETS Method:<\/strong><\/p>\n
The order of use of the dimensions in GROUPING SETS is not important. It always returns the same result.<\/p>\n
SELECT [Location], [Month], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month]),\n[Location],\n[Month],\n()\n)<\/pre>\n
\"\"<\/p>\n
Let’s add 3 fields in our example without grand-total.<\/p>\n
SELECT [Location], [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n([Location], [Month], [Category]),\n([Location], [Month]),\n[Location],\n[Month]\n)<\/pre>\n
\"\"<\/p>\n
One of the advantages offered by GROUPING SETS is that sub-totals can only be created for certain columns. In our previous example, a sub-total row was created for all groups. However, we can create a sub-total for the Month and Category by fixing the location.<\/p>\n
SELECT [Location], [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n[Location], ROLLUP([Month], [Category])\n)<\/pre>\n
\"\"<\/p>\n
Another Example:<\/strong><\/p>\n
SELECT [Location], [Month], [Category], SUM(Price) Endorsement\nFROM [dbo].[Sales]\nGROUP BY\nGROUPING SETS\n(\n[Location], [Category], ROLLUP([Month])\n)<\/pre>\n
\"\"<\/p>\n
CONCLUSION:<\/strong><\/p>\n
With SQL Server 2008, it is recommended to use GROUPING SETS instead of WITH ROLLUP or WITH CUBE operators.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
SQL Server supports grouping of data with GROUP BY since older versions, and also offers WITH ROLLUP and WITH CUBE operators for grand-total and sub-totals. SQL Server 2008 provides a new operator named GROUPING SETS.\u00a0With SQL Server 2008, it is recommended to use GROUPING SETS instead of WITH ROLLUP or WITH CUBE operators. You can …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":470,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[1791,1792,1788,1789,1793,1790],"class_list":["post-8534","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-cube-operator","tag-difference-between-grouping-sets","tag-grouping-sets-operator","tag-rollup","tag-rollup-and-cube","tag-rollup-operator"],"aioseo_notices":[],"yoast_head":"\nGROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"GROUPING SETS Operator in SQL SERVER(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"GROUPING SETS Operator in SQL SERVER(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-26T12:00:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-26T12:31:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png\" \/>\n<meta name=\"author\" content=\"Ahmet KAYMAZ\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmet KAYMAZ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\"},\"author\":{\"name\":\"Ahmet KAYMAZ\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad\"},\"headline\":\"GROUPING SETS Operator in SQL SERVER(TSQL)\",\"datePublished\":\"2019-01-26T12:00:06+00:00\",\"dateModified\":\"2019-01-26T12:31:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\"},\"wordCount\":628,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png\",\"keywords\":[\"CUBE Operator\",\"Difference Between GROUPING SETS\",\"GROUPING SETS Operator\",\"ROLLUP\",\"ROLLUP and CUBE\",\"ROLLUP Operator\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\",\"name\":\"GROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png\",\"datePublished\":\"2019-01-26T12:00:06+00:00\",\"dateModified\":\"2019-01-26T12:31:51+00:00\",\"description\":\"GROUPING SETS Operator in SQL SERVER(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png\",\"width\":670,\"height\":592},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GROUPING SETS Operator in SQL SERVER(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad\",\"name\":\"Ahmet KAYMAZ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g\",\"caption\":\"Ahmet KAYMAZ\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ahmetkaymaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials","description":"GROUPING SETS Operator in SQL SERVER(TSQL)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"GROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials","og_description":"GROUPING SETS Operator in SQL SERVER(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-26T12:00:06+00:00","article_modified_time":"2019-01-26T12:31:51+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png","type":"","width":"","height":""}],"author":"Ahmet KAYMAZ","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ahmet KAYMAZ","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/"},"author":{"name":"Ahmet KAYMAZ","@id":"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad"},"headline":"GROUPING SETS Operator in SQL SERVER(TSQL)","datePublished":"2019-01-26T12:00:06+00:00","dateModified":"2019-01-26T12:31:51+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/"},"wordCount":628,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png","keywords":["CUBE Operator","Difference Between GROUPING SETS","GROUPING SETS Operator","ROLLUP","ROLLUP and CUBE","ROLLUP Operator"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/","name":"GROUPING SETS Operator in SQL SERVER(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png","datePublished":"2019-01-26T12:00:06+00:00","dateModified":"2019-01-26T12:31:51+00:00","description":"GROUPING SETS Operator in SQL SERVER(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4b02629480f.png","width":670,"height":592},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-sets-operator-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"GROUPING SETS Operator in SQL SERVER(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/80688c36fa505cc2cb8533399f77e5ad","name":"Ahmet KAYMAZ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec882e49e815780808a0ba0abd1a4df1199c625ef7357c66e583dedd1b079d31?s=96&d=mm&r=g","caption":"Ahmet KAYMAZ"},"url":"https:\/\/dbtut.com\/index.php\/author\/ahmetkaymaz\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/470"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8534"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8534\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}