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

4.11.22.1.
Grouping
4.11.22.2.
Distinctness
4.11.22.3.
Filtering
4.11.22.4.
Ordering
4.11.22.5.
Ordering WITHIN GROUP
4.11.22.6.
Keeping
4.11.22.7.
ANY_VALUE
4.11.22.8.
ARRAY_AGG
4.11.22.9.
AVG
4.11.22.10.
BIT_AND_AGG
4.11.22.11.
BIT_NAND_AGG
4.11.22.12.
BIT_NOR_AGG
4.11.22.13.
BIT_OR_AGG
4.11.22.14.
BIT_XOR_AGG
4.11.22.15.
BIT_XNOR_AGG
4.11.22.16.
BOOL_AND
4.11.22.17.
BOOL_OR
4.11.22.18.
COLLECT
4.11.22.19.
COUNT
4.11.22.20.
CUME_DIST
4.11.22.21.
DENSE_RANK
4.11.22.22.
EVERY
4.11.22.23.
GROUP_CONCAT
4.11.22.24.
JSON_ARRAYAGG
4.11.22.25.
JSON_OBJECTAGG
4.11.22.26.
LISTAGG
4.11.22.27.
MAX
4.11.22.28.
MEDIAN
4.11.22.29.
MIN
4.11.22.30.
MODE
4.11.22.31.
MULTISET_AGG
4.11.22.32.
PERCENT_RANK
4.11.22.33.
PERCENTILE_CONT
4.11.22.34.
PERCENTILE_DISC
4.11.22.35.
PRODUCT
4.11.22.36.
RANK
4.11.22.37.
SUM
4.11.22.38.
XMLAGG

previous : next

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo