with s1 as(
select * form t1
where 1=1
order by a desc
),
s2 as(
select * form t2
where 1=1
order by a desc
)
select * from s1
union all
select * from s2
sql 的with as 用法
最新推荐文章于 2023-06-06 20:10:51 发布
with s1 as(
select * form t1
where 1=1
order by a desc
),
s2 as(
select * form t2
where 1=1
order by a desc
)
select * from s1
union all
select * from s2