Get startedGet started for free

Assigning row numbers

Records in T-SQL are inherently unordered. Although in certain situations, you may want to assign row numbers for reference. In this exercise, you will do just that.

This exercise is part of the course

Intermediate SQL Server

View Course

Exercise instructions

Write a T-SQL query that assigns row numbers to all records partitioned by TerritoryName and ordered by OrderDate.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT TerritoryName, OrderDate, 
       -- Assign a row number
       ___ 
       -- Create the partitions and arrange the rows
       OVER(PARTITION BY TerritoryName ORDER BY OrderDate) AS OrderCount
FROM Orders
Edit and Run Code