1. 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 1
  • arguments 1
  • AVERAGE_RANK 1
  • average function 1
  • AVG 1

B

  • BETWEEN operator 1
  • binary operators 1

C

  • CASE expressions 1
  • character literal 1
  • child count function 1
  • comparison operators 1
  • concatenation operator 1
  • conditions 1
  • COUNT 1
  • counting functions 1, 2
  • cumulative averages 1

D

  • data types 1
  • DENSE_RANK 1
  • depth function 1
  • difference from future period 1
  • difference from prior period 1, 2
  • DML expressions 1

F

  • future period functions 1, 2, 3

G

  • group comparison operators 1

H

  • HIER_ANCESTOR 1
  • HIER_CHILD_COUNT 1
  • HIER_DEPTH 1
  • HIER_LEVEL 1
  • HIER_ORDER 1
  • HIER_PARENT 1
  • HIER_TOP 1

I

  • identifiers 1
  • IF ... THEN ... ELSE 1
  • IS operator 1

L

  • LAG 1
  • LAG_VARIANCE 1
  • LAG_VARIANCE_PERCENT 1
  • largest values 1
  • later period functions 1, 2, 3
  • LEAD 1
  • LEAD_VARIANCE 1
  • LEAD_VARIANCE_PERCENT 1
  • level depth function 1
  • level function 1
  • LIKE operators 1
  • literal expressions 1

M

  • MAX 1
  • MIN 1
  • moving averages 1

N

  • naming conventions 1
  • NOT operator 1

O

  • object names 1
  • OLAP_DML_EXPRESSION 1
  • ordering function 1

P

  • parent function 1
  • percent difference from future period 1
  • percent difference from prior period 1
  • period-to-date function 1
  • prior period functions 1, 2, 3

Q

  • qualified data references 1
  • quotes
    • double, for reserved words 1
    • in naming conventions 1
    • single, for text literals 1

R

  • RANK 1
  • ranking functions 1, 2, 3, 4
  • ratios 1
  • ROW_NUMBER 1

S

  • SHARE 1
  • smallest values 1
  • sorting functions 1, 2, 3, 4, 5
  • SPL expressions 1
  • string 1
  • SUM 1

T

  • text literal 1
  • top function 1

U

  • unary operators 1

V

  • variance functions 1, 2, 3, 4

W

  • WHEN ... THEN 1
  • windowing functions 1, 2, 3, 4, 5