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.
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
SUM() aggregate function calculates the sum of all values per group.
SELECT sum(ID) FROM BOOK
+-----+ | sum | +-----+ | 10 | +-----+
This example using jOOQ:
Translates to the following dialect specific expressions:
-- All dialects sum(BOOK.ID)