
Information technology - Guidance for the use of database language SQL - Part 5: Row pattern recognition
NORMA vydána dne 1.9.2021
Designation standards: ISO/IEC 19075-5-ed.1.0
Publication date standards: 1.9.2021
The number of pages: 74
Approximate weight : 222 g (0.49 lbs)
Country: International technical standard
Kategorie: Technické normy ISO
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.