ID
1
3
4
5
6
7
8
9
10
.............................................
变成
ID1
LD2
1
3
4
5
6
7
8
9
10
null
语句大概可以这样写:但是我想请教一下有没有更好的方法
select *
from
(select *
from
(select ID,row_number()over(order by getdate()) as row
from search_table) m
where m.row %2=1) a
left join
(select *
from
(select ID,row_number()over(order by getdate()) as row
from search_table) m
where m.row %2=0) b
on a.row 1=b.row