Skip to content

Instantly share code, notes, and snippets.

@mbforr

mbforr/where.sql

Created July 6, 2021 18:44
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mbforr/a7bd687f7fa2b5e6d212fc7fd46021f8 to your computer and use it in GitHub Desktop.
Save mbforr/a7bd687f7fa2b5e6d212fc7fd46021f8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
where.sql
select
state_geom, state_name, state
from
`bigquery-public-data.geo_us_boundaries.states`
# this is a comment - it won't impact your code and you can delete it if you want
# use the where clause to select rows based on a condition
# in this case an exact match to where the state_name column equals Wisconsin
where state_name = 'Wisconsin'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment