
AMDT 1: On-Line Analytical Processing (SQL/OLAP) - Information technology - Database languages - SQL Part 1: Framework (SQL/Framework)
出版:International Organization for Standardization

专家解读视频
This Amendment specifies the syntax and semantics of database language facilities that supporton-line analytical processing.The database language facilities that support on-line analytical processing include: Rank functions. Distribution functions. Inverse distribution functions (percentiles). Hypothetical set functions. Cumulative and other forms of moving aggregates. Variance, standard deviation, covariance, correlation, and linear regression functions.This amendment also incidentally defines several new numeric functions.NOTE 1 The context for this Amendment is described by the Reference Model of Data Management (ISO/IEC 10032:1993).