 | abouchez on Delphi: using IInterface to re… |
 | Peter Wright on Windows command prompt: decrem… |
 | Schalk Versteeg on How To Write Unmaintainable Co… |
 | dummzeuch on Do not make methods protected… |
| Peter Wright on LED Chaser with only 4017… |
Posted by jpluimers on 2016/09/28
Common table expressions are awesome. They work in at least Oracle and SQL Server.
You cannot nest them, but you can use them consecutively. Thanks spender for explaining that:
WITH
x AS
(
SELECT * FROM MyTable
),
y AS
(
SELECT * FROM x
)
SELECT * FROM y
–jeroen
via: sql – Can you create nested WITH clauses for Common Table Expressions? – Stack Overflow.
This entry was posted on 2016/09/28 at 06:00 and is filed under Database Development, Development, OracleDB, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply