采用多次关联技术,这里假设ID为int型的标识 你不妨试试:select ID,field1, total1=Field1 + isnull((select B.field1 from Table1 B where B.ID = (select top 1 C.ID from Table1 C where C.ID<A.ID order by C.ID desc)),0) from Table1 A
忘了再加上排序:select ID,field1, total1=Field1 + isnull((select B.field1 from Table1 B where B.ID = (select top 1 C.ID from Table1 C where C.ID<A.ID order by C.ID desc)),0) from Table1 Aorder by ID
采用多次关联技术,这里假设ID为int型的标识
你不妨试试:select
ID,field1,
total1=Field1 + isnull((select B.field1 from Table1 B
where B.ID = (select top 1 C.ID from Table1 C where C.ID<A.ID order by C.ID desc)),0)
from Table1 A
ID,field1,
total1=Field1 + isnull((select B.field1 from Table1 B
where B.ID = (select top 1 C.ID from Table1 C where C.ID<A.ID order by C.ID desc)),0)
from Table1 Aorder by ID