sql语句

查询语句

SELECT id,goods_id,goods_name,price,ship_org_id,ship_org_name FROM tb_sms_goods where price=0.04 and goods_id="sms-05"

2、求和

 SELECT IFNULL(SUM(send_total), 0) AS sendTotal, IFNULL(SUM(collect_count), 0) AS collectCount,
            IFNULL(SUM(distribute_count), 0) AS distributeCount, IFNULL(SUM(sign_count), 0) AS signCount,
            IFNULL(SUM(sms_cost), 0) AS smsCost
        FROM tb_scan_sms_send_statistic