Following are examples of some common scalar functions. Each example shows the syntax used and the result of applying the function. The examples that follow do not include all the scalar functions. The functions described include:
Avg
AvgNonNull
ColMax
ColMin
Count
CountDistinct
CountNull
CountNonNull
Cume
Sum
Median
Mode
Percentile
Rank
RankAsc
StdDev
StdDevp
Var
Varp