20 Sep 19 · npack ·       Add to Favorites  

Table or Column Alias in Bigquery - Syntax

An alias is a temporary name given to a table, column, or expression present in a query. You can introduce explicit aliases in the SELECT list or FROM clause, or BigQuery will infer an implicit alias for some expressions

Example:

SELECT s.FirstName AS name, LOWER(s.FirstName) AS lname
FROM Singers s;
SELECT s.FirstName, s2.SongName
FROM Singers AS s, (SELECT * FROM Songs) AS s2;

npack

posted on 20 Sep 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied