ISO/IEC 19075-5:2021
ISO/IEC 19075-5:2021



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.

General information 

  •  :  Published
     : 2021-08
  •  : 1
     : 74
  •  : ISO/IEC JTC 1/SC 32 Data management and interchange
  •  :
    35.060 Languages used in information technology

Buy this standard

Format Language
std 1 187 PDF
std 2 187 Paper
  • CHF187

Got a question?

Check out our FAQs

Customer care
+41 22 749 08 88

Opening hours:
Monday to Friday - 09:00-12:00, 14:00-17:00 (UTC+1)

Keep up to date with ISO

Sign up to our newsletter for the latest news, views and product information.