Fungsi Window BigQuery

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

Memberikan peringkat untuk setiap baris tanpa gap. Baris dengan nilai sama mendapat peringkat sama, peringkat berikutnya langsung +1.

Returns the first value in the window frame for each row.

Accesses a value from a previous row in the partition based on the specified offset.

Returns the last value in the window frame for each row.

Accesses a value from a subsequent row in the partition based on the specified offset.

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.

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.

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

Assigns a unique sequential number to each row within a partition, starting at 1. No duplicate values are assigned.