ISO/IEC 19075-5:2021

Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition

Publication date: Sep 1, 2021

General information

Current stage: 60.60 Effective date: Sep 1, 2021

Originator: ISO/IEC

Owner: ISO/IEC JTC 1/SC 32

Type: International Standard

ICS: 35.060

Languages: English

Buying

Status: Published

PDF

Paper

PDF and Paper

Language

Language in which you want to receive the document.

Scope

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.

ISO/IEC 19075-5:2021

Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition

General information

Buying

Scope

Life cycle

PREVIOUSLY

NOW