Click here to Skip to main content
16,021,464 members

Comments by Member 16024872 (Top 1 by date)

Member 16024872 9-Jun-23 8:59am View    
your code's incorrect.
i did mean this:
select * from (with temp1 as (select * from foo) ) t1
union all
select * from (with temp2 as (select * from foo) ) t2