UNLIMITED FREE ACCESS TO THE WORLD'S BEST IDEAS

close
Already an Engineering360 user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your Engineering360 Experience

close
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Webinars & White Papers

ISO/IEC DIS 19075-5

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

active, Most Current
Buy Now
Organization: ISO
Publication Date: 3 June 2020
Status: active
Page Count: 82
ICS Code (Languages used in information technology): 35.060
scope:

This document discusses the syntax and semantics for recognizing patterns in rows of a table, as define in ISO/IEC 9075-2, commonly called "SQL/RPR".

SQL/RPR define 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.

Document History

ISO/IEC DIS 19075-5
June 3, 2020
Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
This document discusses the syntax and semantics for recognizing patterns in rows of a table, as define in ISO/IEC 9075-2, commonly called “SQL/RPR”. SQL/RPR define two features regarding row...
December 15, 2016
Information technology - Database languages - SQL Technical Reports - Part 5: Row Pattern Recognition in SQL
This Technical Report discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in [ISO9075-2].

References

Advertisement