BigQuery

Fungsi SQL BigQuery

Data warehouse serverless dari Google Cloud. 220 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 220 fungsi

UPPER

String

Converts all characters in a string to uppercase. Supports Unicode characters.

Tipe hasil: STRING

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
Previous12345