Index Index A B C D F G H I L M N O P Q R S T U V W A ancestor function 2.7 arguments 1.7.2 AVERAGE_RANK 2.3 average function 2.4 AVG 2.4 B BETWEEN operator 1.4.4 binary operators 1.3.2 C CASE expressions 1.6 character literal 1.5 child count function 2.8 comparison operators 1.4.1 concatenation operator 1.3.3 conditions 1.4 COUNT 2.5 counting functions 2.5, 2.8 cumulative averages 2.4 D data types 1.2 DENSE_RANK 2.6 depth function 2.9 difference from future period 2.18 difference from prior period 2.15, 2.16 DML expressions 2.22 F future period functions 2.17, 2.18, 2.19 G group comparison operators 1.4.2 H HIER_ANCESTOR 2.7 HIER_CHILD_COUNT 2.8 HIER_DEPTH 2.9 HIER_LEVEL 2.10 HIER_ORDER 2.11 HIER_PARENT 2.12 HIER_TOP 2.13 I identifiers 1.1 IF ... THEN ... ELSE 1.6 IS operator 1.4.7 L LAG 2.14 LAG_VARIANCE 2.15 LAG_VARIANCE_PERCENT 2.16 largest values 2.20 later period functions 2.17, 2.18, 2.19 LEAD 2.17 LEAD_VARIANCE 2.18 LEAD_VARIANCE_PERCENT 2.19 level depth function 2.9 level function 2.10 LIKE operators 1.4.8.1 literal expressions 1.5 M MAX 2.20 MIN 2.21 moving averages 2.4 N naming conventions 1.1 NOT operator 1.4.6 O object names 1.1 OLAP_DML_EXPRESSION 2.22 ordering function 2.11 P parent function 2.12 percent difference from future period 2.19 percent difference from prior period 2.16 period-to-date function 2.26 prior period functions 2.14, 2.15, 2.16 Q qualified data references 1.7 quotes double, for reserved words A.1 in naming conventions 1.1 single, for text literals 1.5 R RANK 2.23 ranking functions 2.3, 2.6, 2.24, 2.23 ratios 2.25 ROW_NUMBER 2.24 S SHARE 2.25 smallest values 2.21 sorting functions 2.3, 2.6, 2.24, 2.11, 2.23 SPL expressions 2.22 string 1.5 SUM 2.26 T text literal 1.5 top function 2.13 U unary operators 1.3.1 V variance functions 2.15, 2.16, 2.18, 2.19 W WHEN ... THEN 1.6 windowing functions 2.4, 2.5, 2.20, 2.21, 2.26