{"id":8566,"date":"2019-01-26T12:23:24","date_gmt":"2019-01-26T12:23:24","guid":{"rendered":"https:\/\/dbtut.com\/?p=8566"},"modified":"2019-01-26T12:23:24","modified_gmt":"2019-01-26T12:23:24","slug":"grouping-and-grouping_id-functions-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/","title":{"rendered":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)"},"content":{"rendered":"

 <\/p>\n

We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details in the following articles.<\/p>\n

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

“GROUPING SETS Operator in SQL SERVER(TSQL)<\/a>”<\/p>\n

When you use the WITH ROLLUP and WITH CUBE operators, as you can see in the screenshot above, aggregated columns appear to be null. But because the queried data set has NULL values, some columns may be NULL.<\/p>\n

GROUPING Function:<\/h3>\n

We use the GROUPING function to separate these two NULL types. Using the GROUPING function, we can ensure that the results are more meaningful when we use the ROLLUP and CUBE operators.<\/p>\n

If we continue with the example in the “WITH ROLLUP and WITH CUBE Operators in SQL Server(TSQL)<\/a>” article;<\/p>\n

The first script was written without using the GROUPING function.<\/p>\n

We set another value for records that appear to be NULL because they are aggregated with the second script.<\/p>\n

SELECT [ProductCode],[ProductName],SUM(ProductPrice) AS SUM_ProductPrice\r\nFROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH ROLLUP\r\n\r\nSELECT [ProductCode],\r\n(CASE WHEN GROUPING([ProductName])=1 THEN 'ALL Products' ELSE [ProductName] END) AS [ProductName],\r\nSUM(ProductPrice) AS SUM_ProductPrice\r\nFROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH ROLLUP<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
If we do the same thing for ProductCode column we will get the error. Because ProductCode column’s data type is int. That’s why, we can not set string data for the int column.<\/p>\n
SELECT [ProductCode],[ProductName],SUM(ProductPrice) FROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH CUBE\r\n\r\nSELECT\r\n(CASE WHEN GROUPING([ProductCode])=1 THEN 'Product Code Groups' ELSE [ProductCode] END) AS [ProductCode],\r\n[ProductName],SUM(ProductPrice) AS SUM_ProductPrice\r\nFROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH CUBE<\/pre>\n
Msg 245, Level 16, State 1, Line 5<\/em><\/span><\/p>\n
Conversion failed when converting the varchar value ‘Product Code Groups’ to data type int.<\/em><\/span><\/p>\n
\"\"<\/p>\n
But if you want you can add a column to determine the product code’s null type as follows. If the column is null because the results are aggregated, GP_ProductCode will be 1. If not it will\u00a0 be 0.<\/p>\n
SELECT [ProductCode],[ProductName],SUM(ProductPrice),\r\nGROUPING([ProductCode]) AS GP_ProductCode FROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH CUBE<\/pre>\n
\"\"<\/p>\n
GROUPING_ID Function:<\/h3>\n
The GROUPING_ID function evaluates the values of the columns based on the Base2 number system and returns the corresponding int value as a result.<\/p>\n
The following table I got from msdn has explained the difference between GROUPING_ID function and GROUPING function very well.<\/p>\n
\n\n\n\n\n\n\n\n\n\n\n
\n
Columns aggregated<\/span><\/p>\n<\/td>\n
\n
GROUPING_ID (a, b, c) input = GROUPING(a) + GROUPING(b) + GROUPING(c)<\/span><\/p>\n<\/td>\n
\n
GROUPING_ID () output<\/span><\/p>\n<\/td>\n<\/tr>\n
\n
a<\/p>\n<\/td>\n
\n
100<\/p>\n<\/td>\n
\n
4<\/p>\n<\/td>\n<\/tr>\n
\n
b<\/p>\n<\/td>\n
\n
010<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n<\/tr>\n
\n
c<\/p>\n<\/td>\n
\n
001<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n<\/tr>\n
\n
ab<\/p>\n<\/td>\n
\n
110<\/p>\n<\/td>\n
\n
6<\/p>\n<\/td>\n<\/tr>\n
\n
ac<\/p>\n<\/td>\n
\n
101<\/p>\n<\/td>\n
\n
5<\/p>\n<\/td>\n<\/tr>\n
\n
bc<\/p>\n<\/td>\n
\n
011<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n<\/tr>\n
\n
abc<\/p>\n<\/td>\n
\n
111<\/p>\n<\/td>\n
\n
7<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
In the first query below, we used the GROUPING function for the ProductCode and ProductName columns.<\/p>\n
In the second query, we specified these two columns in the GROUPING_ID function. When you interpret the results according to the table above, you will understand the GROUPING_ID function better.<\/p>\n
SELECT [ProductCode],[ProductName],SUM(ProductPrice),\r\nGROUPING([ProductCode]) AS GP_ProductCode,\r\nGROUPING([ProductName]) AS GP_ProductName FROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH CUBE\r\n\r\n\r\nSELECT [ProductCode],[ProductName],SUM(ProductPrice),\r\nGROUPING_ID([ProductCode],[ProductName]) AS GP_ProductCode_and_ProductName\r\nFROM [dbo].[ProductTable]\r\nGROUP BY [ProductName],[ProductCode]\r\nWITH CUBE<\/pre>\n
\"\"<\/p>\n
Review of the screenshot above:<\/strong><\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
GP_ProductCode<\/strong><\/p>\n<\/td>\n
\n
GP_ProductName<\/strong><\/p>\n<\/td>\n
\n
The combination of two columns:<\/strong><\/p>\n<\/td>\n
\n
GP_ProductCode_and_ProductName<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
01<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
01<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
00<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n<\/tr>\n
\n
0<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
01<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
1<\/p>\n<\/td>\n
\n
11<\/p>\n<\/td>\n
\n
3<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
10<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n<\/tr>\n
\n
1<\/p>\n<\/td>\n
\n
0<\/p>\n<\/td>\n
\n
10<\/p>\n<\/td>\n
\n
2<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n<\/div>\n<\/div>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details in the following articles. “WITH ROLLUP and WITH CUBE Operators in SQL Server(TSQL)“, “GROUPING SETS Operator in SQL SERVER(TSQL)” When you use the WITH ROLLUP and WITH CUBE operators, as …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"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":[1796,1799,1797,1798],"class_list":["post-8566","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-grouping-function","tag-grouping-functionn-in-tsql","tag-grouping_id-function","tag-grouping_id-function-in-tsql"],"aioseo_notices":[],"yoast_head":"\nGROUPING and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"GROUPING and GROUPING_ID Functions 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-and-grouping_id-functions-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 and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-26T12:23:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-and-grouping_id-functions-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)\",\"datePublished\":\"2019-01-26T12:23:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\"},\"wordCount\":405,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png\",\"keywords\":[\"GROUPING Function\",\"GROUPING Functionn in TSQL\",\"GROUPING_ID Function\",\"GROUPING_ID Function in TSQL\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\",\"name\":\"GROUPING and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png\",\"datePublished\":\"2019-01-26T12:23:24+00:00\",\"description\":\"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png\",\"width\":958,\"height\":622},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GROUPING and GROUPING_ID Functions 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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials","description":"GROUPING and GROUPING_ID Functions 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-and-grouping_id-functions-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials","og_description":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-26T12:23:24+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)","datePublished":"2019-01-26T12:23:24+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/"},"wordCount":405,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png","keywords":["GROUPING Function","GROUPING Functionn in TSQL","GROUPING_ID Function","GROUPING_ID Function in TSQL"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/","name":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png","datePublished":"2019-01-26T12:23:24+00:00","description":"GROUPING and GROUPING_ID Functions in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c4c4f273859e.png","width":958,"height":622},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/26\/grouping-and-grouping_id-functions-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"GROUPING and GROUPING_ID Functions 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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8566","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=8566"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/8566\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=8566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=8566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=8566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}