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 *
	,(
		SELECT SUM(SQ.SaleAmount)
		FROM EmployeeSales AS SQ
		WHERE SQ.EmployeeID = ES.EmployeeID
			AND SQ.SaleDate <= ES.SaleDate
		) 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

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