Skip to main content
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Industry solutions
Migration
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Infrastructure as code
SDK, languages, frameworks, and tools
/
Console
English
Deutsch
Español – América Latina
Français
Português – Brasil
中文 – 简体
日本語
한국어
Sign in
BigQuery
Start free
Overview
Guides
Reference
Samples
Resources
Technology areas
More
Overview
Guides
Reference
Samples
Resources
Cross-product tools
More
Console
Quotas and limits
Quotas and limits reference
Troubleshoot quota and limit errors
BigQuery command-line tool
bq command-line tool reference
SQL in BigQuery
GoogleSQL reference
Query syntax
Pipe syntax
General reference
Data types
Lexical structure and syntax
Conversion rules
Format elements
Collation
Text analysis
Expressions
Function calls
Aggregate function calls
Window function calls
Operators
Conditional expressions
Subqueries
Functions
All functions
AEAD encryption functions
Overview
AEAD.DECRYPT_BYTES
AEAD.DECRYPT_STRING
AEAD.ENCRYPT
DETERMINISTIC_DECRYPT_BYTES
DETERMINISTIC_DECRYPT_STRING
DETERMINISTIC_ENCRYPT
KEYS.ADD_KEY_FROM_RAW_BYTES
KEYS.KEYSET_CHAIN
KEYS.KEYSET_FROM_JSON
KEYS.KEYSET_LENGTH
KEYS.KEYSET_TO_JSON
KEYS.NEW_KEYSET
KEYS.NEW_WRAPPED_KEYSET
KEYS.REWRAP_KEYSET
KEYS.ROTATE_KEYSET
KEYS.ROTATE_WRAPPED_KEYSET
Aggregate functions
Overview
AGG
ANY_VALUE
ARRAY_AGG
ARRAY_CONCAT_AGG
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
COUNTIF
GROUPING
LOGICAL_AND
LOGICAL_OR
MAX
MAX_BY
MIN
MIN_BY
STRING_AGG
SUM
Approximate aggregate functions
Overview
APPROX_COUNT_DISTINCT
APPROX_QUANTILES
APPROX_TOP_COUNT
APPROX_TOP_SUM
Array functions
Overview
