Status : Published

Format Language
PDF
Paper
  • CHF173
Convert Swiss francs (CHF) to your currency

Abstract

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, “Null 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”

Standard first page

Read sample 

Preview this standard in our Online Browsing Platform (OBP)

General information

  • Status
     : Published
    Publication date
     : 2022-10
    Stage
    : International Standard published [60.60]
  • Edition
     : 1
    Number of pages
     : 49
  • 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. TC
  5. ISO/IEC JTC 1/SC 32
  6. ISO/IEC 19075-9:2022