id speed1 speed2
1 2.1
2 2.5
3 2.8
4 3.2
id speed1 speed2
1 2.1 2.5
2 2.5 2.8
3 2.8 3.2
4 3.2
请问这个sql怎么写呀
id speed1 speed2
1 2.1
2 2.5
3 2.8
4 3.2
id speed1 speed2
1 2.1 2.5
2 2.5 2.8
3 2.8 3.2
4 3.2
请问这个sql怎么写呀
select t1.id,t1.speed1,t2.speed1 from table t1
left join table t2
on t1.id=t2.id-1
;
然后清原表再插入