SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE EmployeeSales(
  [EmployeeID] INT,
  [SaleDate] DATE,
  [SaleAmount] INT
)

INSERT INTO EmployeeSales VALUES
(1,'2022-06-01',10),
(1,'2022-06-02',20),
(1,'2022-06-03',30),
(2,'2022-06-01',10),
(2,'2022-06-02',10),
(2,'2022-06-03',10)
6 rows affected

SELECT *
FROM EmployeeSales


EmployeeID
SaleDate
SaleAmount


1
2022-06-01
10

1
2022-06-02
20

1
2022-06-03
30

2
2022-06-01
10

2
2022-06-02
10

2
2022-06-03
10


SELECT *
	,SUM(ES.SaleAmount) OVER (
		PARTITION BY ES.EmployeeID ORDER BY ES.SaleDate
		ROWS BETWEEN UNBOUNDED PRECEDING
				AND CURRENT ROW
		) AS RunningTotal
FROM EmployeeSales AS ES


EmployeeID
SaleDate
SaleAmount
RunningTotal


1
2022-06-01
10
10

1
2022-06-02
20
30

1
2022-06-03
30
60

2
2022-06-01
10
10

2
2022-06-02
10
20

2
2022-06-03
10
30


SELECT *
	,SUM(ES.SaleAmount) OVER (
		ORDER BY ES.SaleDate
		) AS RunningTotal
FROM EmployeeSales AS ES


EmployeeID
SaleDate
SaleAmount
RunningTotal


1
2022-06-01
10
20

2
2022-06-01
10
20

2
2022-06-02
10
50

1
2022-06-02
20
50

1
2022-06-03
30
90

2
2022-06-03
10
90


SELECT *
	,SUM(ES.SaleAmount) OVER (
		ORDER BY ES.SaleDate
			,ES.EmployeeID
		) AS RunningTotal
FROM EmployeeSales AS ES


EmployeeID
SaleDate
SaleAmount
RunningTotal


1
2022-06-01
10
10

2
2022-06-01
10
20

1
2022-06-02
20
40

2
2022-06-02
10
50

1
2022-06-03
30
80

2
2022-06-03
10
90

EmployeeID	SaleDate	SaleAmount
1	2022-06-01	10
1	2022-06-02	20
1	2022-06-03	30
2	2022-06-01	10
2	2022-06-02	10
2	2022-06-03	10