Publication CODE |
Title |
ISO/IEC 19075-5:2021 (2021-09) |
INFORMATION TECHNOLOGY - GUIDANCE FOR THE USE OF DATABASE LANGUAGE SQL - PART 5: ROW PATTERN RECOGNITION |
|
Price Excl. VAT |
Total number of pages, tables and drawings |
206.00 €
|
74. |
Description
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.
|
Class |
C990
(IEC PUBLICATIONS IEC PUBLICATIONS)
|
Status |
IEC PUBLICATION |
Situation |
Currently active
|
|
Committee |
ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
|
BEC Approval |
2021-09-01 |
ICS-Code (International Standards Classification) |
35.060
|
NBN Status |
New |
|
IEC publication date |
2021-09-01 |
IEC file modification date |
2021-09-06 |
IEC last modification date |
2021-09-06 |
|