使用 CASE 建立多個分組
在這個練習中，你要撰寫一個 CASE 敘述，依下列區間將 DurationSeconds 的數值分成 5 組：
| DurationSeconds | SecondGroup |
|---|---|
| <= 120 | 1 |
| > 120 and <= 600 | 2 |
| > 600 and <= 1200 | 3 |
| > 1201 and <= 5000 | 4 |
| For all other values | 5 |
本練習屬於課程
SQL Server 中級
練習說明
建立一個新欄位 SecondGroup，依前述區間對 DurationSeconds 欄位的數值進行分類。
動手互動練習
試著完成這個範例程式碼，體驗一下這個練習。
-- Complete the syntax for cutting the duration into different cases
SELECT DurationSeconds,
-- Start with the 2 TSQL keywords, and after the condition a TSQL word and a value
___ ___ (DurationSeconds <= 120) ___ ___
-- The pattern repeats with the same keyword and after the condition the same word and next value
___ (DurationSeconds > 120 AND DurationSeconds <= 600) ___ ___
-- Use the same syntax here
___ (DurationSeconds > 601 AND DurationSeconds <= 1200) ___ ___
-- Use the same syntax here
___ (DurationSeconds > 1201 AND DurationSeconds <= 5000) ___ ___
-- Specify a value
ELSE ___
END AS SecondGroup
FROM Incidents