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.