ISO/IEC DIS 19075-5
Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
|Publication Date:||3 June 2020|
|ICS Code (Languages used in information technology):||35.060|
This document discusses the syntax and semantics for recognizing patterns in rows of a table, as define in ISO/IEC 9075-2, commonly called "SQL/RPR".
SQL/RPR define 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.