效率不怎么好 select id=identity(int,1,1),* into #t from tselect a.name,b.name,c.name,d.name,e.name from (select id,[真实姓名] as name from #t where id % 5=1) a inner join (select id,[真实姓名] as name from #t where id % 5=2) b on a.id=b.id-1 innert join (select id,[真实姓名] as name from #t where id % 5=3) c on a.id=c.id-2 inner join (select id,[真实姓名] as name from #t where id % 5=4) d on a.id=c.id-3 innert join (select id,[真实姓名] as name from #t where id % 5=0) d on a.id=c.id-4
有点错误,是inner join,改一下 select id=identity(int,1,1),* into #t from tselect a.name,b.name,c.name,d.name,e.name from (select id,[真实姓名] as name from #t where id % 5=1) a inner join (select id,[真实姓名] as name from #t where id % 5=2) b on a.id=b.id-1 inner join (select id,[真实姓名] as name from #t where id % 5=3) c on a.id=c.id-2 inner join (select id,[真实姓名] as name from #t where id % 5=4) d on a.id=c.id-3 inner join (select id,[真实姓名] as name from #t where id % 5=0) d on a.id=c.id-4
简化语句 select id=identity(int,1,1),* into #t from tselect a.真实姓名,b.真实姓名,c.真实姓名,d.真实姓名,e.真实姓名 from #t a inner join #t b on a.id=b.id-1 and a.id % 5=1 and b.id % 5=2 inner join #t c on a.id=c.id-2 and a.id % 5=1 and c.id % 5=3 inner join #t d on a.id=c.id-3 and a.id % 5=1 and d.id % 5=4 inner join #t e on a.id=c.id-4 and a.id % 5=1 and e.id % 5=0
select id=identity(int,1,1),* into #t from tselect a.name,b.name,c.name,d.name,e.name
from
(select id,[真实姓名] as name from #t where id % 5=1) a
inner join
(select id,[真实姓名] as name from #t where id % 5=2) b on a.id=b.id-1
innert join
(select id,[真实姓名] as name from #t where id % 5=3) c on a.id=c.id-2
inner join
(select id,[真实姓名] as name from #t where id % 5=4) d on a.id=c.id-3
innert join
(select id,[真实姓名] as name from #t where id % 5=0) d on a.id=c.id-4
select id=identity(int,1,1),* into #t from tselect a.name,b.name,c.name,d.name,e.name
from
(select id,[真实姓名] as name from #t where id % 5=1) a
inner join
(select id,[真实姓名] as name from #t where id % 5=2) b on a.id=b.id-1
inner join
(select id,[真实姓名] as name from #t where id % 5=3) c on a.id=c.id-2
inner join
(select id,[真实姓名] as name from #t where id % 5=4) d on a.id=c.id-3
inner join
(select id,[真实姓名] as name from #t where id % 5=0) d on a.id=c.id-4
select id=identity(int,1,1),* into #t from tselect a.真实姓名,b.真实姓名,c.真实姓名,d.真实姓名,e.真实姓名
from #t a
inner join #t b on a.id=b.id-1 and a.id % 5=1 and b.id % 5=2
inner join #t c on a.id=c.id-2 and a.id % 5=1 and c.id % 5=3
inner join #t d on a.id=c.id-3 and a.id % 5=1 and d.id % 5=4
inner join #t e on a.id=c.id-4 and a.id % 5=1 and e.id % 5=0