名稱排序的最後一個國家
就像你可以取得資料集中第一列的值一樣，你也可以取得最後一列的值。當你想把最新的數值拿來和先前的數值比較時，這特別實用。
本練習屬於課程
PostgreSQL 統計摘要與視窗函式
練習說明
- 回傳每屆奧運舉辦的年份與城市。
- 取得最後一屆奧運舉辦的城市。
動手互動練習
試著完成這個範例程式碼，體驗一下這個練習。
WITH Hosts AS (
SELECT DISTINCT Year, City
FROM Summer_Medals)
SELECT
Year,
City,
-- Get the last city in which the Olympic games were held
___ OVER (
ORDER BY ___ ASC
RANGE BETWEEN
UNBOUNDED PRECEDING AND
UNBOUNDED FOLLOWING
) AS Last_City
FROM Hosts
ORDER BY Year ASC;