phoenix mysql函数_Phoenix 常用函数

AVG ( numericTerm )

COUNT (Term)

COUNT (DISTINCT  Term)

MAX ( term )

MIN ( term )

SUM ( numericTerm )

PERCENTILE_CONT( 0.9 ) WITHIN GROUP (ORDER BY X ASC)

PERCENTILE_DISC( 0.9 ) WITHIN GROUP (ORDER BY X DESC)

PERCENT_RANK( 100 ) WITHIN GROUP (ORDER BY X ASC)

FIRST_VALUE( name ) WITHIN GROUP (ORDER BY salary DESC)

LAST_VALUE( name ) WITHIN GROUP (ORDER BY salary DESC)

NTH_VALUE( name, 2 ) WITHIN GROUP (ORDER BY salary DESC)

STDDEV_POP( X )

STDDEV_SAMP( X )

ARRAY_ELEM(my_array_col, 5)

ARRAY_LENGTH(my_array_col)

10 > ANY(my_array)

10 > ALL(my_array)

MD5(my_column)

INVERT(my_column)

ENCODE(myNumber, 'BASE62')

DECODE('000000008512af277ffffff8', 'HEX')

COALESCE(last_update_date, CURRENT_DATE())

ROUND(number, 2)

CEIL