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

最新推荐文章于 2024-07-30 03:50:29 发布

never123450

最新推荐文章于 2024-07-30 03:50:29 发布

阅读量5.5k

点赞数

分类专栏：工作积累文章标签： mysql

本文链接：https://blog.csdn.net/nevergiveup12345/article/details/50962993

版权

工作积累专栏收录该内容

7 篇文章 0 订阅

订阅专栏

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

SELECT
    ROUND(SUM(a.init_weight), 1) AS thisPageSum
FROM
    (
        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) DESC
LIMIT ?,
 ?
    ) 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_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) DESC

--  [TJ*YF**0004, 3, 2016-03-23 00:00, 2016-03-23 14:11:12]