AVG() |
g_avg(G;S;X) |
For SQL, the function returns the average value. For 1010data, the average of the
values within a given group is returned. |
ABS() |
abs(x) |
Returns the absolute value of a given value. |
ACOS() |
acos(X) |
Returns the arccosine (in radians) of the given value. |
ASIN() |
asin(X) |
Returns the arcsine (in radians) of the given value. |
ATAN() |
atan(X) |
Returns the arctangent (in radians) of the given value. |
BIT_AND() |
bitand(X;Y) |
Returns the bitwise AND of two 32-bit integers. |
BIT_OR() |
bitor(X;Y) |
Returns the bitwise OR of two 32-bit integers. |
BIT_XOR() |
bitxor(X;Y) |
Returns the bitwise XOR (exclusive-OR) of two 32-bit integers. |
CAST(expr AS type) |
int(X) |
Returns the largest integer less than or equal to the given value, expressed as
an integer number. |
real(X) |
Returns the given value expressed as a decimal number. |
CEIL() |
ceil(X) |
Returns the smallest integer greater than or equal to the given value, expressed
as a decimal number. |
COS() |
cos(X) |
Returns the cosine of the given value.Returns the cosine of the given
value. |
COUNT() |
g_cnt(G;S) |
For SQL, the function returns the number of rows. For 1010data the number of rows
within a given group is returned. |
COUNT(DISTINCT expr) |
g_ucnt(G;S;X) |
Returns the number of distinct values within a given group. |
FIRST() |
g_first(G;S;O;X) |
For SQL, the function returns the first value in the designated column. For
1010data the first non-N/A value within a given group is returned. |
g_first1(G;S;O) |
For SQL, the function returns the first value in the designated column. For
1010data, a boolean value indicating whether this is the first row in a given group is
returned. |
LAST() |
g_last(G;S;O;X) |
For SQL, the function returns the last value in the designated column. For
1010data, the last non-N/A value within a given group is returned. |
g_last1(G;S;O) |
For SQL, the function returns the last value in the designated column. For
1010data, a boolean value indicating whether this is the last row in a given group is
returned. |
LOG() |
loge(X) |
Returns the natural logarithm of the given value. |
LOG10() |
log(X;Y) |
For SQL, the base-10 logarithm is returned. For 1010data, the logarithm of the
first given value to the base of the second given value is returned. |
LOG2() |
For SQL, the base-2 logarithm is returned. For 1010data, the logarithm of the
first given value to the base of the second given value is returned. |
MAX() |
max(X;Y) |
For SQL, the function returns the largest value in the designated column. For
1010data, the larger of two given values is returned. |
g_hi(G;S;X) |
For SQL, the function returns the largest value in the designated column. For
1010data, the highest value within a given group is returned. |
MIN() |
min(X;Y) |
For SQL, the function returns the smallest value in the designated column. For
1010data, the smaller of two given values is returned. |
g_lo(G;S;X) |
For SQL, the function returns the smallest value in the designated column. For
1010data, the lowest value within a given group is returned. |
MOD() |
mod(X;Y) |
Returns the modulo of two given values. |
RAND() |
draw(X;Y) |
For SQL, returns a random floating point value. For 1010data, using
X as a seed, random numbers are drawn between 0 and Y-1. ( _ should be used when
selects and links with expansions are sued) |
draw_(X;Y) |
STD() |
g_std(G;S;X) |
For SQL, the function returns the standard deviation of the population. For
1010data, the population standard deviation of values within a given group is
returned. |
r_std(C;S) |
For SQL, the function returns the standard deviation of the population. For
1010data, the standard deviation of values across a given set of columns is
returned. |
SUM() |
g_sum(G;S;X) |
For SQL, the function returns the sum of the values within a column. For
1010data, the sum of values within a given group is returned. |
VARIANCE() |
g_var(G;S;X) |
For SQL, the function returns the variance a population. For 1010data, the
variance of values within a given group is returned. |
