First value in a window
Suppose you want to figure out the first OrderDate in each territory or the last one. How would you do that? You can use the window functions FIRST_VALUE() and LAST_VALUE(), respectively! Here are the steps:
- First, create partitions for each territory
- Then, order by
OrderDate - Finally, use the
FIRST_VALUE()and/orLAST_VALUE()functions as per your requirement
Deze oefening maakt deel uit van de cursus
Intermediate SQL Server
Oefeninstructies
Write a T-SQL query that returns the first OrderDate by creating partitions for each TerritoryName.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT TerritoryName, OrderDate,
-- Select the first value in each partition
___(OrderDate)
-- Create the partitions and arrange the rows
OVER(PARTITION BY TerritoryName ___ OrderDate) AS FirstOrder
FROM Orders