&gt; Common Table Expressions (also: CTE, also referred to as subquery factoring, e.g. in Oracle) are the only way to declare variables in SQL (apart from the obscure WINDOW clause that only PostgreSQL and Sybase SQL Anywhere know).<p>Unless you&#x27;re using all server which supports variables?<p>Not sure if I misunderstood what he&#x27;s trying to say or not.