How to run a query in Standard SQL dialect?

You can set the SQL variant, either legacy SQL or standard SQL, by including a prefix to your query, e.g.:

#standardSQL
SELECT
  weight_pounds, state, year, gestation_weeks
FROM
`bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;
Was this article helpful?
3 out of 3 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.