Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
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
- 3.8.18.1.
- Grouping
- 3.8.18.2.
- Distinctness
- 3.8.18.3.
- Filtering
- 3.8.18.4.
- Ordering
- 3.8.18.5.
- Ordering WITHIN GROUP
- 3.8.18.6.
- Keeping
- 3.8.18.7.
- ANY_VALUE (new)
- 3.8.18.8.
- ARRAY_AGG
- 3.8.18.9.
- AVG
- 3.8.18.10.
- BOOL_AND
- 3.8.18.11.
- BOOL_OR
- 3.8.18.12.
- COLLECT
- 3.8.18.13.
- COUNT
- 3.8.18.14.
- CUME_DIST
- 3.8.18.15.
- DENSE_RANK
- 3.8.18.16.
- EVERY
- 3.8.18.17.
- GROUP_CONCAT
- 3.8.18.18.
- JSON_ARRAYAGG
- 3.8.18.19.
- JSON_OBJECTAGG
- 3.8.18.20.
- LISTAGG
- 3.8.18.21.
- MAX
- 3.8.18.22.
- MEDIAN
- 3.8.18.23.
- MIN
- 3.8.18.24.
- MODE
- 3.8.18.25.
- MULTISET_AGG (new)
- 3.8.18.26.
- PERCENT_RANK
- 3.8.18.27.
- PERCENTILE_CONT
- 3.8.18.28.
- PERCENTILE_DISC
- 3.8.18.29.
- PRODUCT
- 3.8.18.30.
- RANK
- 3.8.18.31.
- SUM
- 3.8.18.32.
- XMLAGG
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!