Account:  - Login  |  Webstore  |  Shopping basket cart
English  |  Français  |  Nederlands

Publication details

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)
Available files
EN version

Status
Status IEC PUBLICATION
Situation Currently active
Origin
Committee ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
Approval
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