| 16.Analytical Functions | ||
| 16.1.Introduction( 6 ) | 16.18.NTILE( 7 ) | |
| 16.2.ROWNUM( 4 ) | 16.19.Nulls First Last( 9 ) | |
| 16.3.ROW_NUMBER( 5 ) | 16.20.OVER( 11 ) | |
| 16.4.RANK( 7 ) | 16.21.PERCENTILE_CONT( 3 ) | |
| 16.5.DENSE_RANK( 8 ) | 16.22.PERCENTILE_DISC( 1 ) | |
| 16.6.PERCENT_RANK( 4 ) | 16.23.RANGE( 4 ) | |
| 16.7.PARTITION_BY( 7 ) | 16.24.ROLLUP( 12 ) | |
| 16.8.CUBE( 8 ) | 16.25.MODEL( 1 ) | |
| 16.9.CUME_DIST( 4 ) | 16.26.SPREADSHEET( 2 ) | |
| 16.10.FIRST_VALUE( 1 ) | 16.27.Top( 1 ) | |
| 16.11.LAST_VALUE( 1 ) | 16.28.UNBOUNDED( 2 ) | |
| 16.12.Group by( 1 ) | 16.29.Window Functions( 11 ) | |
| 16.13.GROUPING( 12 ) | 16.30.HAVING( 1 ) | |
| 16.14.GROUPING_ID( 3 ) | 16.31.Order( 1 ) | |
| 16.15.First( 1 ) | 16.32.Table Joins( 2 ) | |
| 16.16.Last( 1 ) | 16.33.Where( 1 ) | |
| 16.17.LEAD LAG( 5 ) | ||