22 Sep 19 · npack ·       Add to Favorites  

Subqueries in Bigquery - syntax

A subquery is a query that appears inside another statement, and is written inside parentheses. These are also referred to as "sub-SELECTs" or "nested SELECTs". The full SELECT syntax is valid in subqueries

SELECT r.LastName FROM
( SELECT * FROM Roster) AS r;

npack

posted on 22 Sep 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied