Abstract

 Preview

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”


General information 

  • Status
     :  Published
    Publication date
     : 2022-10
  • Edition
     : 1
    Number of pages
     : 49
  • Technical Committee
     : ISO/IEC JTC 1/SC 32 Data management and interchange
  • ICS
     :
    35.060 Languages used in information technology

Sustainable Development Goals

This standard contributes to the following Sustainable Development Goal:

9
Industry, Innovation and Infrastructure

Buy this standard

Format Language
PDF
Paper
  • CHF166

Life cycle


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.

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