New versions: Dev (3.15) | Latest (3.14) | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Old versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 2.6
Aggregate functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Aggregate functions work like Java java.util.stream.Collector, as they aggregate data from a group of data into a new data structure.
This section will first explain concepts common to many aggregate functions, and then proceed to explaining individual aggregate functions supported by jOOQ.
Table of contents
- 4.5.14.1.
- Grouping
- 4.5.14.2.
- Distinctness
- 4.5.14.3.
- Filtering
- 4.5.14.4.
- Keeping
- 4.5.14.5.
- AVG
- 4.5.14.6.
- COUNT
- 4.5.14.7.
- GROUP_CONCAT
- 4.5.14.8.
- LISTAGG
- 4.5.14.9.
- MAX
- 4.5.14.10.
- MEDIAN
- 4.5.14.11.
- MIN
- 4.5.14.12.
- PRODUCT
- 4.5.14.13.
- SUM
The jOOQ User Manual : SQL building : Column expressions : Aggregate functions | previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!