running count for each 2 rows, Sql Server

running count for each 2 rows

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 8, rows affected: 8, absolute service time: 0,16 sec

edit mode | history

  
EmpId
Yr
sales
(No column name)

1
1
2005
12000,00
12000,00

2
1
2006
18000,00
30000,00

3
1
2007
25000,00
25000,00

4
1
2008
25000,00
50000,00

5
1
2009
25000,00
25000,00

6
2
2005
15000,00
15000,00

7
2
2006
6000,00
21000,00

8
2
2007
6000,00
6000,00

λ

                                      .NET NoSQL database for rapid development