34,593
社区成员
发帖
与我相关
我的任务
分享
create TABLE #TT (id INT,tac VARCHAR(2),tbc VARCHAR(2))
INSERT INTO #TT
SELECT 1,'a1','b1' UNION ALL
SELECT 2,'a2','b2' UNION ALL
SELECT 3,'a3','b3' UNION ALL
SELECT 4,'a4','b4' UNION ALL
SELECT 5,'a5','b5'
select T1.*,T2.* from #TT T1 left join #TT T2 on T1.id=T2.id-1 where T1.id%2=1
declare @tmp table (id int identity(1,1),tac char(10),tbc char(10))
insert into @tmp (tac,tbc)
select 'a1','b1'
union all select 'a2','b2'
union all select 'a3','b3'
union all select 'a4','b4'
union all select 'a5','b5'
select a.*,b.*
from @tmp a left join @tmp b on a.id=b.id-1
where a.id % 2=1
select * from (select * from @t where id %2 = 1) a
left join
(select * from @t where id % 2= 0) b
on a.id = b.id-1
SELECT *
FROM TAB1 A
LEFT JOIN TAB1 B
ON A.id=B.id-1
WHERE A.id % 2 = 1