case when and then else 一直报AND 附近语法错误
SELECT
工号,
rpusername,
MAX ( createtime ) createtime,
SUM (CASE WHEN 系数= '1.2系数'
AND (( AND 球镜 >= - 1.75 AND 球镜 <= - 1.25 AND 柱镜 = - 0.00
AND cdefine1 != '2207407' AND cdefine1 != '2207408' AND cdefine1 != '2207409' )
OR ( 球镜 < - 1.00 OR ( 球镜 > - 0.00 AND 球镜 < 0.25 ) OR 球镜 > 1.00 OR 柱镜 < - 4.00 OR 柱镜 > - 0.00 ))
THEN 数量 ELSE 0 END ) '1.2系数',
SUM (折算产量) 折合产量,
SUM (数量) 实际产量
YHX0505
2020/12/04 11:30- sql
- 点赞
- 收藏
- 回答
满意答案
1个回复
