select count(CASE jyje WHEN '1300' THEN '2' ELSE '1' END) as count from tpent_orders where cplx = 6 and left(time,4) ='2019'
chenlw 2019-02-19 16:32 原文
select count(CASE jyje WHEN '1300' THEN '2' ELSE '1' END) as count from tpent_orders where cplx = 6 and left(time,4) ='2019'