Fungsi SQL BigQuery

Alias for CEIL. Rounds a number up to the nearest integer.

Returns the number of characters in a string. An alias for LENGTH, available for standard SQL compatibility.

Converts a Unicode code point value into a string character. The inverse of the ASCII function.

Mengembalikan nilai non-NULL pertama dari daftar expressions.

Converts an array of code points (extended ASCII 0–255) into BYTES.

Converts an array of Unicode code points into a STRING.

Concatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types.

Checks whether a string contains a specified substring. Case-insensitive and supports JSON structures.

Menghitung koefisien korelasi Pearson antara dua kolom numerik.

Menghitung nilai cosinus dari sudut dalam radian.

Menghitung nilai cotangen dari sudut dalam radian (1/TAN).

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.

Menghitung cumulative distribution - proporsi baris dengan nilai kurang dari atau sama dengan baris saat ini.

Returns the current date based on the specified timezone or the default timezone.

Returns the current datetime (date and time without timezone information) based on the specified timezone.

Returns the current time (without a date) based on the specified timezone.

Returns the current timestamp in UTC. This is the most common way to get the current date and time in BigQuery.