Database Reference
In-Depth Information
“ah… feature X is available!” For others, this may be the first time you've
encountered these features, and you might want to pay attention to the
examples more closely.
The advanced SQL features described here include subqueries; join variants
(inner, outer, semi-join and anti-join), and window functions (RANK,
CUME_DIST, and so on). Depending on your background, these may seem
like basic features or they may appear exotic. Either way, they are useful in
BigQuery and are described here.
