 | jpluimers on 3.6 GIG – Public-Mikroti… |
| jpluimers on Adobe Acrobat Reader – C… |
 | jac.las on Root finding and linear progra… |
 | Dr. Wu on Adobe Acrobat Reader – C… |
 | Ihsan on 3.6 GIG – Public-Mikroti… |
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