Window Functions

Index

Row Number Function

${item.topic}
${item.topic}
${item.topic}

Rank Functions

${item.topic}
${item.topic}
${item.topic}

Lead or Lag Functions

${item.topic}
${item.topic}
${item.topic}

Nth Value Functions

${item.topic}
${item.topic}
${item.topic}

Other Window 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.

Row Number Function

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Rank Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Lead or Lag Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Nth Value Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}

Other Window Functions

${item.topic}

${item.syntax}
${item.railroad}

${item.text}

Example:

${item.example}