how to run UNIONALL query in BIGQuery

how to run UNIONALL query in BIGQuery

Its UNION ALL (notice the space). Your query should be:

SELECT 2 AS y 
UNION ALL
SELECT 1 AS y;

You need to use standard SQL.

how to run UNIONALL query in BIGQuery

Leave a Reply

Your email address will not be published.