Skip to content

Instantly share code, notes, and snippets.

@st98

st98/with.sql

Last active August 29, 2015 14:14
Show Gist options
  • Save st98/aece2e1a513ce1e7eaea to your computer and use it in GitHub Desktop.
Save st98/aece2e1a513ce1e7eaea to your computer and use it in GitHub Desktop.
Download ZIP
with 節。
Raw
with.sql
create table t(n int, s text, t text);
insert into t values (1, 'abc', 'hoge');
insert into t values (2, 'def', 'fuga');
with s(a, b, c) as (select * from t) select * from s;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment