1010data for SQL users | Function comparisons | |

SQL Function | 1010data Function | Description |
---|---|---|

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. |