 | Peter Wright on LED Chaser with only 4017… |
 | Maxim Masiutin on Delphi: There is a FastMM4 for… |
 | HeartWare on From Delphi 1: Type Compatibil… |
 | abouchez on From Delphi 1: Type Compatibil… |
 | Remy Lebeau on Can we truly assert that an ar… |
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