注册

[-4083]:引用列未找到

🐐 2025/06/04 192 5 已解决

【DM版本】: DM Database Server 64 V8; DB Version: 0x7000c
【操作系统】:Kylin V10
【CPU】: 海光x86
【问题描述】*:
下面这条sql语句在MySQL下执行正常,请问是having不支持别名操作吗?

SELECT count(ww.id) AS num, sum(if(ww.status IN(12, 13, 9), 1, 0)) AS snum FROM wo_workorder ww WHERE ww.deleted = 0 group by ww.de_demand_id HAVING num = snum;

image.png

回答 0
暂无回答
扫一扫
联系客服