SQL 不新增表 把一张表定义成两张

select ＊from wenjianming a
select a.* from
(select * from a) tba
inner join
(select * from a) tbb
on balabala
是想对比同一张表某个时间段内数据的差别 但不新增表
这个代码有啥问题吗！为啥跑不出来啊:(

with a as (select * from 表)
select a1.*,a2.* from 
(select * from a)  a1
join 
(select * from a)  a2
on a1.id=a2.id

https://blog.csdn.net/qq_32124881/article/details/122908111
瞅瞅这个是不是你要的

你写的这是两个SQL语句吧？一个SQL语句结束后用；断开

你这典型的with as写法可解决