Overview: Standard SQL Reference

BigQuery standard SQL is compliant with the SQL 2011 standard and has extensions that support querying nested and repeated data. If you are using BigQuery legacy SQL, see Legacy SQL Functions and Operators.

Enabling Standard SQL
Standard SQL Data Types
Standard SQL Query Syntax
Standard SQL Functions & Operators
Standard SQL Lexical Structure
Standard SQL User-Defined Functions
Wildcard Tables in Standard SQL
Data Manipulation Language in Standard SQL
DML Syntax in Standard SQL

Was this page helpful? Let us know how we did:

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated February 4, 2019.

Overview: Standard SQL Reference

Send feedback about...