语句块

Select,  Alias, From,  Where, Parameter, Group By, Order By

常见函数

Count, Count(Distinct A), Sum, Max, Min, Avg

特殊函数

Range, Product, Median, Quartile, Mode, SumSQ, PthPercentile, Variance, PopulationVariance, StandardDeviation, StandardError, PopulationStandardDeviation, SumWT, WeightAvg, Covariance, Correlation

四则运算及函数

Sqrt, Sqr, ParseInt, ParseFloat, Abs, Substring, (a+b-c)*b/c

日期函数

Year, Quarter, Month, Week, Day, Hour, Minute, Second, Quarterpart, Monthpart, Weekpart, Daypart, Weekday, Hourpart, Minutepart, Secondpart

Join

支持

SubQuery

支持