956
社区成员
发帖
与我相关
我的任务
分享
SELECT
sum(
CASE WHEN
oh.data_status_id = 10000 or
oh.data_status_id = 10001
THEN 1 ELSE 0 END
) AS data1,
sum(
CASE WHEN oh.data_status_id = 10008 or
oh.data_status_id = 10009 or
oh.data_status_id = 10010 or
oh.data_status_id = 10002 or
oh.data_status_id = 10003 or
oh.data_status_id = 10014 or
oh.data_status_id = 100 or
oh.data_status_id = 200 or
oh.data_status_id = 300 or
oh.data_status_id = 400 or
oh.data_status_id = 700 or
oh.data_status_id = 800
THEN 1 ELSE 0 END) AS data2,
sum(
CASE WHEN oh.data_status_id = 900
THEN 1 ELSE 0 END
) AS data3,
sum(
CASE WHEN oh.data_status_id = 10016
THEN 1 ELSE 0 END
) AS data4,
sum(
CASE WHEN 1 = 1 THEN 1 ELSE 0 END
) AS data5
FROM lscm_ta_order_header oh where oh.status = '1' and oh.if_del = '0'