<select id="getSalesTop10" resultType="com.sky.dto.GoodsSalesDTO">
        SELECT name, sum(od.number) number
        from order_detail od, orders o
        where od.order_id = o.id
        and o.status = 5
        <if test="begin != null">
            and o.order_time &gt; #{begin}
        </if>
        <if test="end != null">
            and o.order_time &lt; #{end}
        </if>
        GROUP BY od.name
        ORDER BY number DESC
        LIMIT 10;
    </select>