Logo icon
    • How it works
    • Telegram
    • GitHub
    • YTsaurus
    • Overview
    • How to try
      • Authentication
        • Overview
        • Fault tolerance
        • Operation options
        • Job Collectives
        • 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 INTERSECT EXCEPT
              • 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
    • Compatibility of cluster components
    • FAQ
    • How to report
    • Event presentations, publications, and workshops
    1. User guide
    2. Data processing
    3. YQL
    4. Syntax
    5. SELECT
    6. FROM SELECT

    FROM ... SELECT ...

    An inverted format, first specifying the data source and then the operation.

    Examples

    FROM my_table SELECT key, value;
    
    FROM a_table AS a
    JOIN b_table AS b
    USING (key)
    SELECT *;
    
    Previous
    FROM AS_TABLE
    Next
    FOLDER