sql第二条数据的某列更新到 第一列的某个字段里

Create Table #TMP
(
ID int identity(1,1),
firstBalance int,
lastBalance int
) 
 
Insert Into #TMP (lastBalance) Values(1)
Insert Into #TMP (lastBalance) Values(3)
Insert Into #TMP (lastBalance) Values(5)
Insert Into #TMP (lastBalance) Values(2)
Insert Into #TMP (lastBalance) Values(9)
Insert Into #TMP (lastBalance) Values(10)
select * from #TMP
Select  (Select lastBalance From #Tmp C Where ID=(Select Min(ID) From #Tmp A Where A.ID>#TMP.ID)) As firstBalance ,lastBalance From #TMP 
Drop Table #TMP

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17