is it possible to use a query as a table? i.e. define a query and use it as if it was a view
this would be so I can define re-usable queries that are used by other queries as if it were a table.
1 Reply
Yes, you can either use a CTE or a subquery for this.