Skip to content

Instantly share code, notes, and snippets.

@krzykamil

krzykamil/with.sql

Created February 13, 2019 12:41
Show Gist options
  • Save krzykamil/8579feff77e6aa3578adbbe064eeed53 to your computer and use it in GitHub Desktop.
Save krzykamil/8579feff77e6aa3578adbbe064eeed53 to your computer and use it in GitHub Desktop.
Download ZIP
SQL WITH syntax
Raw
with.sql
WITH my_subquery AS (SELECT * FROM table_name WHERE column_name_1 = value_1)
SELECT column_name_2 FROM my_subquery
WHERE coulumn_date > '2018-12-08'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment