WITH

TARGIT InMemory supports the standard WITH statement. WITH Statements allow you to break more
complicated SQL logic into more easily handled chunks. They are consumed by the next SELECT statement. They act like temporarily views that are used by the next SQL Select statement.

Example:

with MyCustomTable as ( select * from orders ) 
with MyCustomTable2 as ( select * from customers ) 
select sum(1) from MyCustomTable 
inner join MyCustomTable2 
on MyCustomTable.customerid = MyCustomTable2.customerid

Recursive WITH statements are supported using the RECURSIVE keyword before the recursive SELECT.

Example:

WITH RecursiveExample as (select 5 as level 
union all 
recursive select level-1 as level 
from RecursiveExample 
where level > 0 ) 
select * from RecursiveExample