How to cycle through the addition and subtraction of the current row data and the previous row data in sql

This article mainly explains "how to cycle through the addition and subtraction of the current row of data and the previous row of data in sql", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to cycle through the addition and subtraction of the current row of data and the previous row of data in sql.

In the following example, it is relatively simple to use the cursor to cycle through the data in the table # temptable, and then add the argument1 in the current row and the previous row to the argument2 in the current row.

-drop table # temptablecreate table # temptable (argument1 int, argument2 int, argument3 datetime) declare @ rowcount int,@argument1 int,@argument2 nvarchar (50), @ argument3 datetimeset @ rowcount=1set @ argument1=1set @ argument2=0set @ argument3=GETDATE () while (@ rowcount