mysql求某个列的前10条记录的总和

来源：互联网发布：php tp框架 c函数编辑：程序博客网时间：2024/05/22 07:57

mysql求某个列的前10条记录的总和

SELECT    ROUND(SUM(a.init_weight), 1) AS thisPageSumFROM    (        SELECT            t.init_weight,            (                SELECT                    sum(t1.weight)                FROM                    TransportationDelivery t1                WHERE                    t1.publish_id = t.publish_id                AND t. STATUS != '00'                AND t1. STATUS != '00'                AND t1.platform_id = t.platform_id            ) AS trans_weight        FROM            GoodsOrderM AS t        WHERE            1 = 1        AND t. STATUS != '10'        AND t.platform_id = ?        AND if_can_show = 'Y'        AND (t.company_id = ?)        AND date_format(            create_date,            '%Y-%m-%d %H:%i'        ) >= ?        AND date_format(            create_date,            '%Y-%m-%d %H:%i'        ) <= ?        ORDER BY        IF (t.appoint_company_id = 0, 0, 1) DESC,    IF (        t.docu_type = '1' || t.docu_type = '2',    IF (        t.docu_pri_sec = '1',        t.publish_id,        t.pri_publish_id    ),    t.publish_id    ) DESC,IF (    t.docu_type = '1' || t.docu_type = '2',    t.docu_pri_sec *- 1,    t.publish_id) DESC,IF (weight - trans_weight > 0, 1, 0) DESCLIMIT ?, ?    ) AS a-- [TJ*YF**0004, 3, 2016-03-23 00:00, 2016-03-23 14:11:12, 0, 10]

求某列的总和

SELECT    ROUND(SUM(t.init_weight), 1) AS totalSum,    (        SELECT            sum(t1.weight)        FROM            TransportationDelivery t1        WHERE            t1.publish_id = t.publish_id        AND t. STATUS != '00'        AND t1. STATUS != '00'        AND t1.platform_id = t.platform_id    ) AS trans_weightFROM    GoodsOrderM AS tWHERE    1 = 1AND t. STATUS != '10'AND t.platform_id = ?AND if_can_show = 'Y'AND (t.company_id = ?)AND date_format(    create_date,    '%Y-%m-%d %H:%i') >= ?AND date_format(    create_date,    '%Y-%m-%d %H:%i') <= ?ORDER BYIF (t.appoint_company_id = 0, 0, 1) DESC,IF (    t.docu_type = '1' || t.docu_type = '2',IF (    t.docu_pri_sec = '1',    t.publish_id,    t.pri_publish_id), t.publish_id) DESC,IF (    t.docu_type = '1' || t.docu_type = '2',    t.docu_pri_sec *- 1,    t.publish_id) DESC,IF (weight - trans_weight > 0, 1, 0) DESC--  [TJ*YF**0004, 3, 2016-03-23 00:00, 2016-03-23 14:11:12]

0 0