Fungsi SQL BigQuery

Returns the remainder of dividing two numbers (modulo operation).

Normalizes a Unicode string to a canonical form. Useful for consistent string comparisons across different Unicode representations.

Normalizes a Unicode string and applies case-folding for correct Unicode-aware case-insensitive comparisons.

Returns the value at the Nth position in the window frame.

Divides rows within a partition into a specified number of buckets and assigns a bucket number to each row.

Mengembalikan NULL jika kedua expression sama, otherwise mengembalikan expression1.

Alias untuk IFNULL. Mengembalikan null_replacement jika expression NULL.

Mengakses elemen array menggunakan zero-based index.

Mengakses elemen array menggunakan one-based index.

Parses a string into a DATE based on the specified format. The inverse of FORMAT_DATE.

Converts a string into a DATETIME type based on the specified format.

Converts a JSON string into the native JSON type.

Converts a time string into a TIME type based on the specified format.

Converts a string to a TIMESTAMP type with timezone support.

Computes a continuous percentile value using linear interpolation across the values in a group.

Returns the actual value at the nearest percentile without interpolation.

Menghitung percentile rank relatif dari setiap baris. Nilai antara 0 dan 1, menunjukkan persentase baris yang lebih rendah.

Calculates base raised to the power of exponent (base^exponent).

Mengkonversi sudut dari derajat ke radian.

Generates a random number between 0 (inclusive) and 1 (exclusive).

Assigns a rank to each row. Rows with equal values receive the same rank, and there is a gap after ties.

Returns TRUE if the value matches the regular expression. Useful for pattern matching and format validation.

Extracts the first substring that matches the regular expression. If the pattern has a capturing group, returns that group instead.

Extracts all substrings that match the regular expression and returns them as an array.