使用 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