# Aggregate Functions ## Index ### General Aggregate Functions
${item.topic} | ${item.topic} | ${item.topic}
### Binary Set Functions
${item.topic} | ${item.topic} | ${item.topic}
### Ordered Aggregate Functions
${item.topic} | ${item.topic} | ${item.topic}
### Hypothetical Set Functions
${item.topic} | ${item.topic} | ${item.topic}
### Inverse Distribution Functions
${item.topic} | ${item.topic} | ${item.topic}
### JSON Aggregate Functions
${item.topic} | ${item.topic} | ${item.topic}
## Details Click on the header of the function to switch between railroad diagram and BNF. Non-standard syntax is marked in green. Compatibility-only non-standard syntax is marked in red, don't use it unless you need it for compatibility with other databases or old versions of H2. ## General Aggregate Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example} ## Binary Set Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example} ## Ordered Aggregate Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example} ## Hypothetical Set Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example} ## Inverse Distribution Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example} ## JSON Aggregate Functions ### ${item.topic}
    ${item.syntax}
${item.railroad} ${item.text} Example: ${item.example}