sql查询条数

sql查询条数

select count(1) 总记录数 或者 SELECT SUM(CASE WHEN STATUS = '1' THEN 1 ELSE 0 END) as paysum FROM `ien_pay_log` GROUP BY uid