Logo icon
    • YTsaurus
    • Overview
    • How to try
      • Authentication
        • Overview
        • Fault tolerance
        • Operation options
        • Chunk auto-merge at operation output
        • Chunk auto-merge on the master server side
        • Recommendations
        • Root file system images
        • Switching between tables
          • Introduction
            • Overview
            • Lexical structure
            • Expressions
            • ACTION
            • CREATE TABLE
            • COMMIT
            • DISCARD
            • DROP TABLE
            • GROUP BY
            • EXPORT и IMPORT
            • FLATTEN
            • INSERT
            • INTO RESULT
            • JOIN
            • PRAGMA
            • PROCESS
            • REDUCE
              • Overview
              • TEMPORARY TABLE
              • FROM
              • FROM AS_TABLE
              • FROM SELECT
              • FOLDER
              • WalkFolders
              • DISTINCT
              • UNIQUE DISTINCT
              • UNION
              • CONCAT
              • VIEW
              • WITH
              • WITHOUT
              • WHERE
              • ORDER BY
              • ASSUME ORDER BY
              • LIMIT OFFSET
              • SAMPLE
              • TABLESAMPLE
            • SUBQUERY
            • USE
            • VALUES
            • WINDOW
            • Unsupported statements
      • Jupyter Notebooks
    • Release notes
    • FAQ
    • How to report
    • Event presentations, publications, and workshops
    1. User guide
    2. Data processing
    3. YQL
    4. Syntax
    5. SELECT
    6. WHERE

    WHERE

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

    Example

    SELECT key FROM my_table
    WHERE value > 0;
    
    Previous
    WITHOUT
    Next
    ORDER BY