Fungsi SQL BigQuery

Calculates approximate quantile boundaries from numeric data. Uses an efficient approximate algorithm for large datasets, returning an array with n+1 elements.

Returns the approximate most frequently occurring elements along with their counts. Uses a highly efficient approximate algorithm for large datasets.

Returns the approximate elements with the highest total weight. Similar to APPROX_TOP_COUNT but ranked by sum of weights rather than count.

Creates an array from a subquery or literal elements.

Collects values from multiple rows into an ARRAY. A powerful BigQuery function for building nested data structures.

Concatenates two or more arrays into a single array.

Concatenates multiple arrays into a single array. Useful when each row already contains an array and you want to merge them all into one.

Mengecek apakah semua elemen dalam array adalah unik (tidak ada duplikat).

Returns the number of elements in an array.

Membalik urutan elemen dalam array.

Joins array elements into a string using a delimiter.

Returns the ASCII value (code point) of the first character in the string.

Menghitung arc sinus (inverse sine) - sudut dalam radian yang memiliki sinus x.

Menghitung arc tangen (inverse tangent) - sudut dalam radian yang memiliki tangen x.

Menghitung arc tangen dari y/x dengan mempertimbangkan kuadran. Lebih akurat dari ATAN(y/x).

Calculates the average (mean) of numeric values in a column. Ignores NULL values and supports multiple numeric types in BigQuery.

Performs a bitwise AND operation across all values in a group. Returns a value where each bit is 1 only if all input values have that bit set to 1.

Menghitung jumlah bit yang bernilai 1 dalam representasi binary.

Performs a bitwise OR operation across all values in a group. Returns a value where each bit is 1 if at least one input value has that bit set to 1.

Performs a bitwise XOR operation across all values in a group. Returns a value where each bit is 1 if the number of input values with that bit set to 1 is odd.