Fungsi SQL BigQuery

Returns one value from a group non-deterministically. Useful for retrieving a value from a column that is not being aggregated when all values in the group are the same.

Estimates the number of distinct values using the HyperLogLog++ algorithm. Much faster and less resource-intensive than COUNT(DISTINCT) for large datasets.

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.

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

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

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.

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.

Menghitung koefisien korelasi Pearson antara dua kolom numerik.

Counts the number of rows or non-NULL values in a column. A fundamental aggregate function in BigQuery for large-scale data analysis.

Counts the number of rows that satisfy a given condition. Provides a more concise and readable syntax compared to COUNT with CASE or IF.

Menghitung kovarians populasi antara dua kolom numerik.

Menghitung kovarians sample antara dua kolom numerik.

Returns TRUE if ALL values in the group are TRUE. Acts as an aggregated AND operator, useful for verifying that every condition in a set is met.

Returns TRUE if AT LEAST ONE value in the group is TRUE. Acts as an aggregated OR operator, useful for checking whether any condition in a set is met.

Returns the maximum value from a column or expression. Supports numeric, string, date/time, and boolean types in BigQuery.

Returns the minimum value from a column or expression. Supports numeric, string, date/time, and boolean types in BigQuery.

Calculates the sample standard deviation of numeric values. Measures how spread out the data is from its mean. An alias for STDDEV_SAMP.

Calculates the population standard deviation of numeric values. Uses the N divisor formula (not N-1), suitable when the data represents an entire population.

Calculates the sample standard deviation of numeric values. Uses the N-1 divisor formula (Bessel's correction), suitable for sample data that represents a larger population.

Concatenates string values from multiple rows into a single string with a specified delimiter. Very useful for creating lists or comma-separated values in BigQuery.