where
statement is used to define a local filter, which restricts the scope of any statements contained within its body.where
statement.where
statement is used to define a local filter that restricts the effect of the statements located in the lines between the opening {
and closing }
.where
statement.{
must be preceded with white-space may be positioned on the same line as the where
statement or may be on a line of its own}
must be located on a line of its ownwhere
statement must reference at least one column name as detailed in the Column names section belowwhere
statement.where
statement is to selectively process rows of data based on the expression, it is a requirement that the condition references one or more column names.[like_this]
.["like this"]
. The reason that the quotes must be located within the brackets is that otherwise the brackets (along with their contents) would be treated as a literal string.""
. The following will delete all rows in the DSET Azure.usage
where the quantity column is empty:where { ... }
to modify the contents of a column that is being used by the expression.set
is used to update the values in a column then the new values will be used for all subsequent evaluations of the expression, which will affect all following statements in the where
block.where
statement, usingset copy_of_column as original_column
where
statement has completed..*
at the end of an expression).where
statement:where
statement but are unaffected by the expression (and as a result work exactly the same as if they were used outside the where
statement body)