{"id":2090,"date":"2025-02-14T15:16:26","date_gmt":"2025-02-14T08:16:26","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=2090"},"modified":"2025-02-14T15:27:05","modified_gmt":"2025-02-14T08:27:05","slug":"postgresql-grouping-sets","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-tutorial\/postgresql-grouping-sets\/","title":{"rendered":"PostgreSQL GROUPING SETS"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the PostgreSQL GROUPING SETS<\/code> to create multiple groupings within the same query.<\/p>\n\n\n\n

PostgreSQL GROUPING SETS Overview #<\/a><\/h2>\n\n\n\n

In PostgreSQL, the GROUPING SETS<\/code> is an advanced feature of the GROUP BY<\/a><\/code> clause that allows you to create multiple groupings within the same query.<\/p>\n\n\n\n

The GROUP BY<\/code> clause allows you to create a single grouping. To create multiple groupings, you can create multiple queries using GROUP BY<\/code> clauses.<\/p>\n\n\n\n

Alternatively, you combine multiple queries with GROUP BY<\/code> clauses using UNION<\/a><\/code> operators.<\/p>\n\n\n\n

The GROUPING SETS<\/code> enables multiple groupings within the same query without using multiple queries or the UNION<\/code> operator.<\/p>\n\n\n\n

Here’s the general syntax of the GROUPING SETS<\/code>:<\/p>\n\n\n

SELECT<\/span>\n  column1,\n  column2,\n  aggregate_function (column3)\nFROM<\/span>\n  table_name<\/span>\nGROUP<\/span> BY<\/span>\n  GROUPING SETS<\/span> (\n      (column1, column2), \n      (column1), \n      (column2), \n      ()\n   );<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n