select count(CASE jyje WHEN '1300' THEN '2' ELSE '1' END) as count from tpent_orders where cplx = 6 and left(time,4) ='2019'
转载于:https://www.cnblogs.com/chenlw/p/10401873.html
select count(CASE jyje WHEN '1300' THEN '2' ELSE '1' END) as count from tpent_orders where cplx = 6 and left(time,4) ='2019'
转载于:https://www.cnblogs.com/chenlw/p/10401873.html