Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition (Adopted ISO/IEC 19075-5:2021, first edition, 2021-08)
Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC.
For brevity, this Standard will be referred to as CSA ISO/IEC 19075-5 throughout.
This Standard replaces CAN/CSA-ISO/IEC TR 19075-5:18 (adopted ISO/IEC TR 19075-5:2016).
The International Standard was reviewed by the CSA TCIT under the jurisdiction of the CSA Strategic Steering Committee on Information and Communications Technology and deemed acceptable for use in Canada. This Standard has been formally approved, without modification, by the Technical Committee and has been developed in compliance with Standards Council of Canada requirements for National Standards of Canada. It has been published as a National Standard of Canada by CSA Group.
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.
Information technology — Database languages — SQL Technical Reports — Part 5: Row Pattern Recognition in SQL (Adopted ISO/IEC TR 19075-5:2016, first edition, 2016-12-15)