![](https://csdnimg.cn/release/download_crawler_static/2182292/bg14.jpg)
xx
Treatment of NULLs as Input to Window Functions.......................................................... 21-16
Windowing Functions with Logical Offset........................................................................... 21-16
Centered Aggregate Function................................................................................................. 21-18
Windowing Aggregate Functions in the Presence of Duplicates...................................... 21-19
Varying Window Size for Each Row ..................................................................................... 21-20
Windowing Aggregate Functions with Physical Offsets.................................................... 21-21
FIRST_VALUE and LAST_VALUE Functions..................................................................... 21-21
Reporting Aggregate Functions ................................................................................................... 21-22
RATIO_TO_REPORT Function .............................................................................................. 21-24
LAG/LEAD Functions.................................................................................................................... 21-25
LAG/LEAD Syntax.................................................................................................................. 21-25
FIRST/LAST Functions.................................................................................................................. 21-26
FIRST/LAST Syntax................................................................................................................. 21-26
FIRST/LAST As Regular Aggregates.................................................................................... 21-26
FIRST/LAST As Reporting Aggregates................................................................................ 21-27
Inverse Percentile Functions......................................................................................................... 21-28
Normal Aggregate Syntax....................................................................................................... 21-28
Inverse Percentile Example Basis.................................................................................... 21-28
As Reporting Aggregates ................................................................................................. 21-30
Inverse Percentile Restrictions................................................................................................ 21-31
Hypothetical Rank and Distribution Functions....................................................................... 21-32
Hypothetical Rank and Distribution Syntax......................................................................... 21-32
Linear Regression Functions......................................................................................................... 21-33
REGR_COUNT Function......................................................................................................... 21-34
REGR_AVGY and REGR_AVGX Functions......................................................................... 21-34
REGR_SLOPE and REGR_INTERCEPT Functions ............................................................. 21-34
REGR_R2 Function................................................................................................................... 21-35
REGR_SXX, REGR_SYY, and REGR_SXY Functions .......................................................... 21-35
Linear Regression Statistics Examples................................................................................... 21-35
Sample Linear Regression Calculation.................................................................................. 21-35
Frequent Itemsets............................................................................................................................ 21-36
Other Statistical Functions............................................................................................................ 21-37
Descriptive Statistics................................................................................................................. 21-37
Hypothesis Testing - Parametric Tests .................................................................................. 21-37
Crosstab Statistics ..................................................................................................................... 21-38