Available in versions: Dev (3.18) | Latest (3.17) | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8
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.7.15.1.
- Grouping
- 4.7.15.2.
- Distinctness
- 4.7.15.3.
- Filtering
- 4.7.15.4.
- Ordering
- 4.7.15.5.
- Ordering WITHIN GROUP
- 4.7.15.6.
- Keeping
- 4.7.15.7.
- ARRAY_AGG
- 4.7.15.8.
- AVG
- 4.7.15.9.
- BOOL_AND
- 4.7.15.10.
- BOOL_OR
- 4.7.15.11.
- COLLECT (new)
- 4.7.15.12.
- COUNT
- 4.7.15.13.
- CUME_DIST
- 4.7.15.14.
- DENSE_RANK
- 4.7.15.15.
- EVERY
- 4.7.15.16.
- GROUP_CONCAT
- 4.7.15.17.
- LISTAGG
- 4.7.15.18.
- MAX
- 4.7.15.19.
- MEDIAN
- 4.7.15.20.
- MIN
- 4.7.15.21.
- MODE
- 4.7.15.22.
- PERCENT_RANK
- 4.7.15.23.
- PERCENTILE_CONT
- 4.7.15.24.
- PERCENTILE_DISC
- 4.7.15.25.
- PRODUCT
- 4.7.15.26.
- RANK
- 4.7.15.27.
- 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!