International Standard
ISO/IEC 19075-5:2021
Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
Reference number
ISO/IEC 19075-5:2021
Edition 1
2021-08
© ISO 2024
International Standard
Read sample
Published (Edition 1, 2021)

ISO/IEC 19075-5:2021

Format
Language
CHF 194
Convert Swiss francs (CHF) to your currency

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.

General information

  • Status
     : Published
    Publication date
     : 2021-08
    Stage
    : International Standard published [60.60]
  • Edition
     : 1
    Number of pages
     : 74
  • Technical Committee :
    ISO/IEC JTC 1/SC 32
    ICS :
    35.060 
  • RSS updates

Life cycle

Sustainable Development Goals

This standard contributes to the following Sustainable Development Goal

9
Industry, Innovation and Infrastructure

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)

  2. Store
  3. Standards catalogue
  4. ICS
  5. 35
  6. 35.060
  7. ISO/IEC 19075-5:2021