WHERE

Filtering rows in the SELECT result based on a condition in row-oriented or column-oriented.

Example

SELECT key FROM my_table
WHERE value > 0;