ydb/yql/essentials/docs/en/syntax/select/where.md

WHERE

Filtering rows in the SELECT result based on a condition in tables.

Example

SELECT key FROM my_table
WHERE value > 0;