Skip to main content
Documentation
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Generative AI
Industry solutions
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Google Cloud SDK, languages, frameworks, and tools
Infrastructure as code
Migration
Related sites
close
Google Cloud Home
Free Trial and Free Tier
Architecture Center
Blog
Contact Sales
Google Cloud Developer Center
Google Developer Center
Google Cloud Marketplace
Google Cloud Marketplace Documentation
Google Cloud Skills Boost
Google Cloud Solution Center
Google Cloud Support
Google Cloud Tech Youtube Channel
/
English
Deutsch
Español – América Latina
Français
Português – Brasil
中文 – 简体
日本語
한국어
Console
Sign in
BigQuery
Guides
Reference
Samples
Resources
Contact Us
Start free
Documentation
Guides
Reference
Samples
Resources
Technology areas
More
Cross-product tools
More
Related sites
More
Console
Contact Us
Start free
Quotas and limits
Quotas and limits reference
Troubleshoot quota 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
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
A
