BigQuery

Fungsi SQL BigQuery

Data warehouse serverless dari Google Cloud. 28 fungsi tersedia.

SemuaPostgreSQLPostgreSQLDuckDBDuckDBSnowflakeSnowflakeBigQueryBigQueryMySQLMySQL

Filter berdasarkan kategori:

SemuaAggregate(28)String(48)Date & Time(35)Window(13)Math(35)JSON(20)Array(14)Conditional(7)Conversion(10)

Menampilkan 4 dari 28 fungsi dalam kategori Aggregate

SUM

Aggregate

Calculates the total sum of numeric values in a column. Supports multiple numeric types and is highly efficient for large-scale data analysis in BigQuery.

Tipe hasil: Same as input type (INT64, FLOAT64, NUMERIC, or BIGNUMERIC)

VARIANCE

Aggregate

Calculates the sample variance of numeric values. Variance is the square of the standard deviation. This is an alias for VAR_SAMP.

Tipe hasil: FLOAT64

VAR_POP

Aggregate

Calculates the population variance of numeric values. Uses the N divisor formula, suitable when the data represents an entire population.

Tipe hasil: FLOAT64

VAR_SAMP

Aggregate

Calculates the sample variance of numeric values. Uses the N-1 divisor formula (Bessel's correction), suitable for sample data.

Tipe hasil: FLOAT64
Previous12