分组查询(每组指定查N条数据)SQL

 sum为指定条数

    <select id="selectOverAllDesc" resultType="com.ruubypay.markting.redenvelope.job.pojo.points.CardExpiredPojo">
        set @order_num=0;set@amo=0;
        SELECT a.id, a.`amount` , a.`packet_num`,b.rownum FROM card_expired as a INNER JOIN(
            SELECT id, `amount` ,
                   case when @amo = `amount`
                            then @order_num:=@order_num+1
                        else @order_num:=1 end rownum,
                   @amo:=`amount`
            FROM card_expired where uid = 0
            order by `amount`,id desc ) as b on a.id = b.id WHERE b.rownum&lt;=#{sum}
    </select>