Getting Row Number in SQL Server Assigning a row number to your results in SQL is a common task and is doing so is pretty straight-forward so I won’t spend a lot of time on it here. Take a look at the syntax here: USE AdventureWorks2008R2; GO SELECT PersonType, FirstName, LastName, ROW_NUMBER() OVER(PARTITION BY PersonType […]