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 *
FROM EmployeeSales AS L
JOIN EmployeeSales AS R ON L.EmployeeID = R.EmployeeID
ORDER BY L.EmployeeID
	,L.SaleDate


EmployeeID
SaleDate
SaleAmount
EmployeeID
SaleDate
SaleAmount


1
2022-06-01
10
1
2022-06-01
10

1
2022-06-01
10
1
2022-06-02
20

1
2022-06-01
10
1
2022-06-03
30

1
2022-06-02
20
1
2022-06-01
10

1
2022-06-02
20
1
2022-06-02
20

1
2022-06-02
20
1
2022-06-03
30

1
2022-06-03
30
1
2022-06-01
10

1
2022-06-03
30
1
2022-06-02
20

1
2022-06-03
30
1
2022-06-03
30

2
2022-06-01
10
2
2022-06-01
10

2
2022-06-01
10
2
2022-06-02
10

2
2022-06-01
10
2
2022-06-03
10

2
2022-06-02
10
2
2022-06-01
10

2
2022-06-02
10
2
2022-06-02
10

2
2022-06-02
10
2
2022-06-03
10

2
2022-06-03
10
2
2022-06-01
10

2
2022-06-03
10
2
2022-06-02
10

2
2022-06-03
10
2
2022-06-03
10


SELECT *
FROM EmployeeSales AS L
JOIN EmployeeSales AS R ON L.EmployeeID = R.EmployeeID
WHERE L.SaleDate >= R.SaleDate
ORDER BY L.EmployeeID
	,L.SaleDate


EmployeeID
SaleDate
SaleAmount
EmployeeID
SaleDate
SaleAmount


1
2022-06-01
10
1
2022-06-01
10

1
2022-06-02
20
1
2022-06-01
10

1
2022-06-02
20
1
2022-06-02
20

1
2022-06-03
30
1
2022-06-01
10

1
2022-06-03
30
1
2022-06-02
20

1
2022-06-03
30
1
2022-06-03
30

2
2022-06-01
10
2
2022-06-01
10

2
2022-06-02
10
2
2022-06-01
10

2
2022-06-02
10
2
2022-06-02
10

2
2022-06-03
10
2
2022-06-01
10

2
2022-06-03
10
2
2022-06-02
10

2
2022-06-03
10
2
2022-06-03
10


SELECT L.EmployeeID
	,L.SaleDate
	,MAX(L.SaleAmount) AS SaleAmount
	,SUM(R.SaleAmount) AS RunningTotal
FROM EmployeeSales AS L
JOIN EmployeeSales AS R ON L.EmployeeID = R.EmployeeID
	AND L.SaleDate >= R.SaleDate
GROUP BY L.EmployeeID
	,L.SaleDate
ORDER BY L.EmployeeID
	,L.SaleDate


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