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

Customers Who Bought This Also Bought

 

About This Item

 

Full Description

This document discusses the syntax and semantics for including online analytic processing (OLAP) capabilities
in SQL, as defined in ISO/IEC 9075-2.
It discusses the following features regarding OLAP capabilities of the SQL language:
— Feature T611, "Elementary OLAP operations",
— Feature T612, "Advanced OLAP operations",
— Feature T614, “NTILE function”,
— Feature T615, “LEAD and LAG functions”,
— Feature T616, “ treatment option for LEAD and LAG functions”,
— Feature T617, "FIRST_VALUE and LAST_VALUE functions",
— Feature T618, "NTH_VALUE function",
— Feature T619, "Nested window functions",
— Feature T620, "WINDOW clause: GROUPS option",
— Feature T621, "Enhanced numeric functions"

 

Document History

  1. ISO/IEC 19075-9:2022

    👀 currently
    viewing


    Information technology - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)

    • Most Recent
  2. ISO/IEC TR 19075-9:2020


    Information technology database languages - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities

    • Historical Version