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
            • PROCESS
            • REDUCE
              • Overview
              • TEMPORARY TABLE
              • FROM
              • FROM AS_TABLE
              • FROM SELECT
              • FOLDER
              • WalkFolders
              • DISTINCT
              • UNIQUE DISTINCT
              • UNION
              • CONCAT / EACH / RANGE / LIKE / FILTER
              • 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
    We use cookies to ensure that you have the best experience on our website. If you continue to use our website, we assume that you are happy with it.