Selecting data from specific columns

Written by

Improved by

Updated at March 6, 2025

You can fetch data from all columns as well as from their their subsets. You can also rename existing columns and create new ones.

For example:

Select data from the age, last_visit_time, and region columns.
Rename region to area.
Change the release_date column type from Int32 to DateTime.

SELECT
    VendorID,                           -- List column names (VendorID, trip_distance)
    trip_distance,                      -- separated by commas.
    fare_amount AS fare,                -- You can use AS to rename columns
    (total_amount/1000) AS total_amount_thousand_dollars, -- or give a name to any expression.
    CAST(VendorID as Uint32) AS vendorID -- You can change data type using CAST.
FROM
    `tutorial-analytics`
LIMIT 10

View the example in the right-hand section and click Run.
Query results are available in the Result tab as a table or schema.

Selecting data from specific columns

See also

Was the article helpful?