Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022!
SELECT – WINDOW – (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16