Skip to content

Instantly share code, notes, and snippets.

@sudarsang

sudarsang/with.sql

Last active December 30, 2015 08:09
Show Gist options
  • Save sudarsang/7800331 to your computer and use it in GitHub Desktop.
Save sudarsang/7800331 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
with.sql
WITH R1 AS
(SELECT * FROM A JOIN B ON A.X = B.Y WHERE A.Z = 'abcd'
) ,
R2 AS
(SELECT * FROM C WHERE D.X = 'pqrs' AND D.Y IN (SELECT Y FROM R1)
) ,
R3 AS
(SELECT * FROM E JOIN R2 ON E.X = R2.Y WHERE E.Z = 'pqrs' AND R2.P ='bla bla'
)
SELECT R3.somthing,
tab.something
FROM R3,
anotherTable tab
WHERE THIS= 'THAT'
ORDER BY R3.P
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment