ISO/IEC 19075-5:2021
Information technology - Guidance for the use of database language SQL - Part 5: Row pattern recognition
Abstract
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.
- 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.
Additional information
Publication type | International Standard |
---|---|
Publication date | 2021-09-01 |
Edition | 1.0 |
Available language(s) | English |
TC/SC | ISO/IEC JTC 1/SC 32 - Data management and interchangerss |
ICS | 35.060 - Languages used in information technology |
Pages | 74 |
File size | 2071 KB |
The following test report forms are related:
Share your publications
Learn how to share your publications with your colleagues, using networking options.
Payment information
Our prices are in Swiss francs (CHF). We accept all major credit cards (American Express, Mastercard and Visa, JCB and CUP), PayPal and bank transfers as form of payment.
Keep in touch
Keep up to date with new publication releases and announcements with our free IEC Just Published email newsletter.
Contact customer services
Please send your enquiry by email or call us on +41 22 919 02 11 between 09:00 – 16:00 CET Monday to Friday.