Knowledge Gateway
Unlock your learning potential with industry insights and standards that matter. Share your email to begin.
Unlock your learning potential with industry insights and standards that matter. Share your email to begin.
Status : Active
Standard Type : Main
Document No : ISO/IEC 19075-5:2021
Document Year : 2021
Pages : 74
Edition : 1.0
Section Volume : Data management and interchange (ISOIEC JTC 1.SC 32)
This document discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in ISO/IEC 9075-2, commonly called “SQL/RPR”.
SQL/RPR defines two features regarding row pattern recognition:
— Feature R010, “Row pattern recognition: FROM clause”
— Feature R020, “Row pattern recognition: WINDOW clause”
These two features have considerable syntax and semantics in common, the principle difference being whether the syntax is placed in the FROM clause or in the WINDOW clause.