Calculating mode (I)
Unfortunately, there is no function to calculate the mode, the most recurring value in a column. To calculate the mode:
- First, create a CTE containing an ordered count of values using
ROW_NUMBER() - Write a query using the CTE to pick the value with the highest row number
In this exercise, you will write the CTE needed to calculate the mode of OrderPrice.
Deze oefening maakt deel uit van de cursus
Intermediate SQL Server
Oefeninstructies
- Create a CTE
ModePricethat returns two columns (OrderPriceandUnitPriceFrequency). - Write a query that returns all rows in this CTE.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Create a CTE Called ModePrice which contains two columns
___ ___ (___, ___)
___
(
SELECT OrderPrice,
ROW_NUMBER()
OVER(PARTITION BY OrderPrice ORDER BY OrderPrice) AS UnitPriceFrequency
FROM Orders
)
-- Select everything from the CTE
___