Language:
    • Available Formats
    • Options
    • Availability
    • Priced From ( in USD )
    • Printed Edition
    • Ships in 1-2 business days
    • $250.00
    • Add to Cart

Customers Who Bought This Also Bought

 

About This Item

 

Full Description

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.

 

Document History

  1. ISO/IEC 19075-5:2021

    👀 currently
    viewing


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

    • Most Recent
  2. ISO/IEC TR 19075-5:2016


    Information technology - Database languages - SQL Technical Reports - Part 5: Row Pattern Recognition in SQL

    • Historical Version