标准摘要
[中文适用范围]： 本文件讨论了ISO/IEC 9075-2中定义的表行中的模式识别的语法和语义，通常称为“SQL/RPR”。SQL/RPR定义了两个特征：——特征R010，“行模式识别：FROM子句”——特征R020，“行模式识别：WINDOW子句”。这两个功能在语法和语义上有许多共同之处，主要区别在于符号是放置在FROM子句还是WINDOW子句中。 [外文原描述]： 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 - Guidance for the use of database language SQL - Part 5: Row pattern recognition