SUM(CASE 现在日供水量 WHEN <1000 and =>200 THEN 1 ELSE 0 END), 改为 SUM(CASE WHEN 现在日供水量<1000 and 现在日供水量>=200 THEN 1 ELSE 0 END),
怎么会??你运行一下这个例子看看。 Declare @A Int Set @A =900 Select SUM(CASE WHEN @A<1000 and @A>=200 THEN 1 ELSE 0 END)
SELECT 区县, [乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END), [村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END), [x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 < 1000 AND 现在日供水量 >= 200 THEN 1 ELSE 0 END), [x1000b] = SUM(CASE 现在日供水量 WHEN 400 THEN 现在日供水量 ELSE 0 END) FROM jzgstjb GROUP BY 区县你看看嘛!!
改好了,再试试。SELECT 区县, [乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END), [村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END), [x1000a] = SUM(CASE WHEN 现在日供水量 <1000 AND 现在日供水量 >= 200 THEN 1 ELSE 0 END), [x1000b] = SUM(CASE 现在日供水量 WHEN 400 THEN 现在日供水量 ELSE 0 END) FROM jzgstjb GROUP BY 区县
哈哈 我发现了他把 "CASE WHEN 现在日供水量" 写成了 "CASE 现在日供水量 WHEN 现在日供水量" 了
SELECT 区县, [乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END), [村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END), [x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END), FROM jzgstjb GROUP BY 区县现在这个没错吧, 但还是提示“>”有错误
哦,是这个SELECT 区县, [乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END), [村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END), [x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END) FROM jzgstjb GROUP BY 区县但还是同样的问题
SELECT 区县, [乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END), [村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END), [x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量>=200 THEN 1 ELSE 0 END) FROM jzgstjb GROUP BY 区县如果我把中间的"现在日供水量>="去掉,就没问题,请问?为什么呀
[x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END), 改为 [x1000a] = SUM(CASE WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END),
改为
SUM(CASE WHEN 现在日供水量<1000 and 现在日供水量>=200 THEN 1 ELSE 0 END),
Declare @A Int
Set @A =900
Select SUM(CASE WHEN @A<1000 and @A>=200 THEN 1 ELSE 0 END)
[乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END),
[村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END),
[x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 < 1000 AND
现在日供水量 >= 200 THEN 1 ELSE 0 END),
[x1000b] = SUM(CASE 现在日供水量 WHEN 400 THEN 现在日供水量 ELSE 0 END)
FROM jzgstjb
GROUP BY 区县你看看嘛!!
[乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END),
[村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END),
[x1000a] = SUM(CASE WHEN 现在日供水量 <1000 AND
现在日供水量 >= 200 THEN 1 ELSE 0 END),
[x1000b] = SUM(CASE 现在日供水量 WHEN 400 THEN 现在日供水量 ELSE 0 END)
FROM jzgstjb
GROUP BY 区县
[乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END),
[村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END),
[x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END),
FROM jzgstjb
GROUP BY 区县现在这个没错吧,
但还是提示“>”有错误
[乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END),
[村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END),
[x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END)
FROM jzgstjb
GROUP BY 区县但还是同样的问题
[乡镇] = SUM(CASE 供水范围 WHEN '乡镇或跨乡镇' THEN 1 ELSE 0 END),
[村级] = SUM(CASE 供水范围 WHEN '村级' THEN 1 ELSE 0 END),
[x1000a] = SUM(CASE 现在日供水量 WHEN 现在日供水量>=200 THEN 1 ELSE 0 END)
FROM jzgstjb
GROUP BY 区县如果我把中间的"现在日供水量>="去掉,就没问题,请问?为什么呀
改为
[x1000a] = SUM(CASE WHEN 现在日供水量 >= 200 THEN 1 ELSE 0 END),