汇总sql

<select id="getMaxIdOfLimitedCdr" parameterType="map"
            resultType="int">
        <![CDATA[
            SELECT
                MAX(id)
            FROM
                (
                    SELECT id
                    FROM ${tableName} limit #{startIndex},#{limitCount}
                ) AS tmp
        ]]>
    </select>

posted @ 2013-04-08 10:06  J. Lingear  阅读(97)  评论(0编辑  收藏  举报