Logo icon
    • Contents
    • Quick start
    • Concepts
    • For DevOps
    • For Developers
      • Getting started
      • YQL tutorial
        • Creating a table
        • Adding data to a table
        • Selecting data from all columns
        • Selecting data from specific columns
        • Sorting and filtering
        • Data aggregation
        • Additional selection criteria
        • Joining tables with JOIN
        • Inserting and updating data with REPLACE
        • Inserting and updating data with UPSERT
        • Inserting data with INSERT
        • Updating data with UPDATE
        • Deleting data
        • Adding and deleting columns
        • Deleting a table
      • Example applications
      • Primary keys
      • Secondary indexes
      • Query plans optimization
      • Batch upload
      • Paging
      • Timeouts
      • System views
      • Change Data Capture
      • Terraform
      • Custom attributes
    • For Security Engineers
    • For Contributors
    • Reference
    • Recipes
    • Troubleshooting
    • Questions and answers
    • Downloads
    1. For Developers
    2. YQL tutorial
    3. Selecting data from all columns

    Selecting data from all columns

    Select all columns from the table using SELECT:

    Note

    We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.

    SELECT         -- Data selection operator.
    
        *          -- Select all columns from the table.
    
    FROM episodes; -- The table to select the data from.
    
    COMMIT;
    

    Was the article helpful?

    Previous
    Adding data to a table
    Next
    Selecting data from specific columns