SQL Reference

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 Query Reference (legacy SQL).

Enabling Standard SQL
Migrating from Legacy SQL
Data Types
Query Syntax
Functions & Operators
Lexical Structure
Working with Arrays
User-Defined Functions
Data Manipulation Language
DML Syntax

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 December 22, 2016.

Send feedback about...