BigQuery: Syntax Flashcards
SELECT * EXCEPT does not …?
exclude columns without names. Why?
SELECT * REPLACE statement does not change the ….?
names or order of the columns. However it can change the value and the value type.
The SELECT * EXCEPT statement specifies the names of ….?
one or more columns to exclude from the result. All matching the column names are omitted from the output
An item in a SELECT list can also take the form of …?
expression.*
items in the SELECT list can be …?
expressions. These expressions evaluate to a single value and produce one output column. with an optional exsplicit alias. Why?
You can use the WITH clause to …?
emulate a temporary table name .
Square brackets[ ] indicate…?
Notation rules
optional clauses
Parentheses ( ) indicate …?
Notaion rules
literal parentheses.
the vertical bar | indicates…?
Notation Rules
a logical OR
Curly braces ` { } ` eclose a set ….?
of options
A comma followed by an ellipsis within square brackets [ , ...] indicates…?
that the preceding item can repeat in a comma-separated list.
Query statements scan one or more tables or expressions and ….?
return the computed result rows.
Items in a SELECT list can be expressions. these expressions evalutate to a ….?
single value and produce one output column.
A ` SELECT ALL` statement returns …?
all rows. including duplicate rows.
a subquery is a query that appears ….?
inside another query statement. subqueries are also referred to as sub-SELECTs or nested SELECTs
a subquery inside an experssion is interpreted as …?
a scalar subquery. A scalar subquery must select a single column.
