Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
GROUP BY clause
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
GROUP BY can be used to create unique groups of data, to form aggregations, to remove duplicates and for other reasons. It will transform your previously defined set of table expressions, and return only one record per unique group as specified in this clause.
Table of contents
- 3.5.3.10.1.
- GROUP BY columns
- 3.5.3.10.2.
- GROUP BY column index
- 3.5.3.10.3.
- GROUP BY tables
- 3.5.3.10.4.
- GROUP BY ROLLUP
- 3.5.3.10.5.
- GROUP BY CUBE
- 3.5.3.10.6.
- GROUP BY GROUPING SETS
- 3.5.3.10.7.
- GROUP BY empty grouping set
| previous : next |
References to this page
- Using table expressions in the GROUP BY clause
- Using the empty grouping set in GROUP BY
- The HAVING clause of the SELECT statement
- Lexical and logical SELECT clause order
- Scalar functions
- The ARRAY constructor by subquery operator
- How aggregate functions interact with GROUP BY
- Aggregating a subset of a group's data using FILTER
- The window function PARTITION BY clause
- User-defined aggregate functions
- GROUP BY <column index>
- Pattern based transformations: Unnecessary DISTINCT
- Pattern based transformations: Unnecessary GROUP BY expressions
- Pattern based transformations: Unnecessary scalar subquery
- Don't do this in SQL: rely on implicit ordering
- Don't do this in SQL: SELECT DISTINCT
Feedback
Do you have any feedback about this page? We'd love to hear it!