逻辑

KKSU

2024-07-26 35498647cf3d8c5939b9f10ce24cc44e2192794b

逻辑

 src/main/resources/mapper/dapp/DappStorageMapper.xml

@@ -145,15 +145,16 @@
    <select id="selectSumByAmountDescFiveToFive" resultType="cc.mrbird.febs.dapp.entity.DappStorage">
        SELECT
            member_id memberId,
            sum(amount) amount
            sum(amount) amount,
            MIN(create_time) as createTime
        FROM
            dapp_storage
        where
            create_time &gt;= #{startTime}
        GROUP BY
            member_id,create_time
            member_id
        ORDER BY
            amount DESC,create_time ASC
            amount DESC,createTime ASC
            limit #{offset},#{count}
    </select>