Skip to main content

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 expression
You can specify several conditions using logical operators. For example:
WHERE hasValue(rating) && rating > 650

This 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!