Window

COUNT_WINDOW

Snowflake

Menghitung running count atau total count menggunakan window function.

Tipe hasil: NUMBER

Syntax

SQL

COUNT(*|expression) OVER ([PARTITION BY ...] [ORDER BY ...])

Parameter

*|expressionANYwajib

* untuk semua baris, atau column untuk non-NULL

Contoh Penggunaan

Running Count and Percentage

SQL

1 SELECT
2   name,
3   COUNT(*) OVER (ORDER BY hire_date) as employee_number,
4   COUNT(*) OVER () as total_employees,
5   ROUND(100.0 * COUNT(*) OVER (ORDER BY hire_date) / COUNT(*) OVER (), 1) as pct
6 FROM employees;

Penomoran dan persentase karyawan berdasarkan tanggal hire.

Kembali ke Snowflake Functions

1	SELECT
2	name,
3	COUNT(*) OVER (ORDER BY hire_date) as employee_number,
4	COUNT(*) OVER () as total_employees,
5	ROUND(100.0 * COUNT() OVER (ORDER BY hire_date) / COUNT() OVER (), 1) as pct
6	FROM employees;