ISO/IEC 19075-5:2021
Current
The latest, up-to-date edition.
Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users
English
01-09-2021
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.
Important note : Users cannot be edited or removed once added to your Multi user PDF.Access your standards online with a subscription
Features
-
Simple online access to standards, technical information and regulations.
-
Critical updates of standards and customisable alerts and notifications.
-
Multi-user online standards collection: secure, flexible and cost effective.