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.