Using the WHERE clause
The WHERE clause is used to filter out the items that do not satisfy a condition given by an expression.
The WHERE keyword should be followed by a simple or conditional
expression that returns a
Boolean:
WHERE expressionYou can specify several conditions using logical operators. For
example:
WHERE hasValue(rating) && rating > 650This clause should be used after a FROM, an UNNEST or a JOIN clause. If the query block contains a LET clause, the WHERE should be placed after it.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!