I want to create a custom function MAXBy(Id, Amount) for the OVER clause in SQL Server.
SELECT
Id,
[Datetime],
[OrderAmount],
MAXBy([Amount], [Id]) OVER (ORDER BY [Datetime] ROWS BETWEEN 99 PRECEDING AND CURRENT ROW) AS MaxAmountOrderIdIn100Last
FROM [Order]
1