Available Expressions

3 min

aggregations average returns the average of the values in the column syntax avg(column) > double count returns the count of non null rows (also known as records) in the selected data syntax count(column) > bigint max returns the largest value found in the column syntax max(column) > \[same as input] min returns the smallest value found in the column syntax min(column) > \[same as input] sum adds up all the values of the column syntax sum(column) > \[same as input] math functions absolute returns the absolute (positive) value of the specified column syntax abs(column) > \[same as input] cube root returns the cube root ofthe number syntax cbrt(column) > double ceil rounds a decimal up (ceil as in ceiling) syntax ceil(column) > \[same as input] exponential returns euler's number, e, raised to the power of the supplied number syntax exp(column) > double floor rounds a decimal number down syntax floor(column) > \[same as input] ln returns the natural logarithm of?the number syntax ln(column) > double log10 returns the base 10 log of the number syntax log10(column) > double round rounds a decimal number either up or down to the nearest integer value syntax round(column) > \[same as input] signum returns the signum function of the number syntax sign(column) > \[same as input] string functions length returns the number of characters in string syntax length(column) > bigint reverse returns string with the characters in reverse order syntax reverse(column) > varbinary