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}