注意:在数据量大时(超过3000条)速度慢 Select Resource.lngResourceID,Resource.dblQuantity, Sum(Resource.dblQuantity) From Resource inner Join Resource As Resource1 On Resource.lngResourceID>Resource1.lngResourceID Group By Resource.lngResourceID,Resource.dblQuantity order by Resource.lngResourceID,Resource.dblQuantity
Select Resource.lngResourceID,Resource.dblQuantity, Sum(Resource.dblQuantity)
From Resource inner Join Resource As Resource1 On
Resource.lngResourceID>Resource1.lngResourceID
Group By Resource.lngResourceID,Resource.dblQuantity
order by Resource.lngResourceID,Resource.dblQuantity