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.
Aggregate functions
Supported by ✅ 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.11.26.1.
- Grouping
- 3.11.26.2.
- Distinctness
- 3.11.26.3.
- Filtering
- 3.11.26.4.
- Ordering
- 3.11.26.5.
- Ordering WITHIN GROUP
- 3.11.26.6.
- Keeping
- 3.11.26.7.
- ANY_VALUE
- 3.11.26.8.
- APPROX_COUNT_DISTINCT (new)
- 3.11.26.9.
- APPROX_PERCENTILE_CONT (new)
- 3.11.26.10.
- APPROX_PERCENTILE_DISC (new)
- 3.11.26.11.
- ARRAY_AGG
- 3.11.26.12.
- AVG
- 3.11.26.13.
- LISTAGG (binary)
- 3.11.26.14.
- BIT_AND_AGG
- 3.11.26.15.
- BIT_NAND_AGG
- 3.11.26.16.
- BIT_NOR_AGG
- 3.11.26.17.
- BIT_OR_AGG
- 3.11.26.18.
- BIT_XOR_AGG
- 3.11.26.19.
- BIT_XNOR_AGG
- 3.11.26.20.
- BOOL_AND
- 3.11.26.21.
- BOOL_OR
- 3.11.26.22.
- COLLECT
- 3.11.26.23.
- COUNT
- 3.11.26.24.
- CUME_DIST
- 3.11.26.25.
- DENSE_RANK
- 3.11.26.26.
- EVERY
- 3.11.26.27.
- GROUP_CONCAT
- 3.11.26.28.
- JSON_ARRAYAGG
- 3.11.26.29.
- JSON_OBJECTAGG
- 3.11.26.30.
- LISTAGG
- 3.11.26.31.
- MAX
- 3.11.26.32.
- MAX_BY
- 3.11.26.33.
- MEDIAN
- 3.11.26.34.
- MIN
- 3.11.26.35.
- MIN_BY
- 3.11.26.36.
- MODE (ordered)
- 3.11.26.37.
- MODE (unordered)
- 3.11.26.38.
- MULTISET_AGG
- 3.11.26.39.
- PERCENT_RANK
- 3.11.26.40.
- PERCENTILE_CONT
- 3.11.26.41.
- PERCENTILE_DISC
- 3.11.26.42.
- PRODUCT
- 3.11.26.43.
- RANK
- 3.11.26.44.
- SUM
- 3.11.26.45.
- XMLAGG
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!