1. 学ぶ
  2. /
  3. コース
  4. /
  5. Intermediate SQL Server

Connected

演習

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.

指示

100 XP

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