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
Important note : Users cannot be edited or removed once added to your Multi user PDF.
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.
| DocumentType |
Standard
|
| Pages |
74
|
| PublisherName |
International Organization for Standardization
|
| Status |
Current
|
| Supersedes |
| Standards | Relationship |
| BS ISO/IEC 19075-5:2021 | Identical |
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.