1. 学习
    2. /
  2. 课程
    3. /
  3. 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.