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.

3.11.21.1.: Grouping
3.11.21.2.: Distinctness
3.11.21.3.: Filtering
3.11.21.4.: Ordering
3.11.21.5.: Ordering WITHIN GROUP
3.11.21.6.: Keeping
3.11.21.7.: ANY_VALUE
3.11.21.8.: ARRAY_AGG
3.11.21.9.: AVG
3.11.21.10.: BIT_AND_AGG
3.11.21.11.: BIT_NAND_AGG
3.11.21.12.: BIT_NOR_AGG
3.11.21.13.: BIT_OR_AGG
3.11.21.14.: BIT_XOR_AGG
3.11.21.15.: BIT_XNOR_AGG
3.11.21.16.: BOOL_AND
3.11.21.17.: BOOL_OR
3.11.21.18.: COLLECT
3.11.21.19.: COUNT
3.11.21.20.: CUME_DIST
3.11.21.21.: DENSE_RANK
3.11.21.22.: EVERY
3.11.21.23.: GROUP_CONCAT
3.11.21.24.: JSON_ARRAYAGG
3.11.21.25.: JSON_OBJECTAGG
3.11.21.26.: LISTAGG
3.11.21.27.: MAX
3.11.21.28.: MEDIAN
3.11.21.29.: MIN
3.11.21.30.: MODE
3.11.21.31.: MULTISET_AGG
3.11.21.32.: PERCENT_RANK
3.11.21.33.: PERCENTILE_CONT
3.11.21.34.: PERCENTILE_DISC
3.11.21.35.: PRODUCT
3.11.21.36.: RANK
3.11.21.37.: SUM
3.11.21.38.: XMLAGG

previous : next

References to this page

Feedback

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

Tell us a little bit about yourself and join our newsletter (examples)

Aggregate functions

Table of contents

References to this page

Feedback

Community

Support

Legal

Documentation