注册

无效列名

苹果肌! 2021/08/20 1383 1 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm-8
【操作系统】:
【CPU】:
【问题描述】*:
SQL适配问题:
select
count(1) as count ,
CAST( sum( CASE sfcg WHEN ‘000’ THEN 1 ELSE 0 END ) / count( 1 ) * 100 AS DECIMAL ( 10, 2 ) ) AS successRate,
DATE_FORMAT( cjsj, ‘%Y-%m-%d %H:%i’) sj
from T_SJYYKF_JK_FWRZ
where 1=1 AND cjsj <= ‘2021-08-18 23:00:00’ AND cjsj >= ‘2021-08-17 23:00:00’
group by sj
order by sj
LIMIT 0, 50000

异常:无效的列名[sj]

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