SELECTCASE a.AFTER_QUALITY
WHEN'0'THEN'过免维期'WHEN'1'THEN'未过免维期'ELSE'错误数据'ENDAS AFTER_QUALITY
FROM
t_maintain_log a
1
2
3
4
5
6
7
8
9
10
11
1
2
3
4
5
6
7
8
9
10
11
数据库表内容: 运行结果: (2)判断该字段的范围
SELECT
d.[单项编号] 单项编号,
c.[单项财务收入],
e.[单项合同金额],
CASEWHEN c.单项财务收入 isNULLor c.单项财务收入 <0THEN'无收入'ELSE'有收入'ENDAS 有无收入,
CASEWHEN e.单项合同金额 ISNULLOR e.单项合同金额 < 0THEN'无合同'ELSE'有合同'ENDAS 有无合同
FROM
[BI_单项_FOR_ANALYSE] d
LEFTJOIN (
SELECT
sr.[单项编号],
SUM (sr.[单项财务收入]) 单项财务收入
FROM
[BI_单项财务收入_FOR_ANALYSE] AS sr
GROUPBY
sr.[单项编号]
) c ON d.[单项编号] = c.[单项编号]
LEFTJOIN (
SELECT
mx.[单项编号],
SUM (mx.[单项合同金额]) 单项合同金额
FROM
BI_合同明细_FOR_ANALYSE AS mx
GROUPBY
mx.[单项编号]
) e ON d.[单项编号] = e.[单项编号];
(1)枚举这个字段的各个可能的值,对枚举到的每一个具体的值单独作出对应的处理 举例说明SELECT CASE a.AFTER_QUALITYWHEN '0' THEN '过免维期'WHEN '1' THEN '未过免维期'ELSE '错误数据'END AS AFTER_QUALITYFROM t_maintain_log a12345678