摘要:
SELECT count(1) all_num, IFNULL( sum( CASE WHEN a.pay_status = 1 THEN 1 ELSE 0 END ), 0 ) success_num, IFNULL( sum( CASE WHEN a.pay_status = 2 THEN 1 阅读全文
摘要:
SELECT @rownum := @rownum +1 as xh,a.* FROM (select @rownum :=0) r,requisition_base a ORDER BY id desc; SELECT @rownum := @rownum + 1 id, m.* FROM (SE 阅读全文