Window FunctionsIndexRow Number Function
Rank Functions
Lead or Lag Functions
Nth Value Functions
Other Window Functions
DetailsClick 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.railroad}
${item.text} Example: ${item.example} Rank Functions${item.topic}
${item.railroad}
${item.text} Example: ${item.example} Lead or Lag Functions${item.topic}
${item.railroad}
${item.text} Example: ${item.example} Nth Value Functions${item.topic}
${item.railroad}
${item.text} Example: ${item.example} Other Window Functions${item.topic}
${item.railroad}
${item.text} Example: ${item.example} |