Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics.

RANK (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16

SELECT – OVER Clause (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16