急，在线等小问题

[dada9527]

select怎么后边的减前边的呀？

有一列
col
1
3
6
9
15
22


怎么整？？
3-1
6-3
9-6
15-9
22-15

[dada9527]

人呢人呢

[Andy__Huang]

這個要用臨時表

select id=identity(int,1,1),col into tab from tb

select col=a.col-b.col from (select * from tab where id>1)a
left join tab b on a.id=b.id

drop table tab

[Andy__Huang]

改一下

select id=identity(int,1,1),col into tab from tb

select col=a.col-b.col from (select * from tab where id>1)a
left join tab b on a.id=b.id+1

drop table tab

[dada9527]

噢，不用林时表不成吗？

[Andy__Huang]

create table tb(col numeric(10))
Insert into tb
select '1'
union all select '3'
union all select '6'
union all select '9'
union all select '15'
union all select '22'

select id=identity(int,1,1),col into tab from tb

select col=a.col-b.col from (select * from tab where id>1)a
left join tab b on a.id=b.id+1

drop table tab

--結果
col
----------
2
3
3
6
7

[dada9527]

先谢谢海洋

[clx333]

楼上的真快啊

[dada9527]

我天，振么麻烦腻呀

[Andy__Huang]

不用臨時表我不知道了？象這種最好是用臨時表了

[dada9527]

还有别的办法没？

[Ncaidexiaoniao]

create table test(col numeric(10))
Insert into test
select '1'
union all select '3'
union all select '6'
union all select '9'
union all select '15'
union all select '22'
select id=identity(int),col into #t from test
drop table #t
select * from #t
select b.col-a.col col from (select * from #t)a,(select * from #t where id>1)b
where b.id=a.id+1
drop table #t
还是用临时表的好