mybatis中app的查询语句

 

 

　　

SELECT * FROM (
        SELECT (@rownum := @rownum + 1) AS rownum,c.* FROM
        (SELECT @rownum := 0) r,
        (
        select * from sys_user_work where creator = #{params.userId}
        ) c
        <!--ORDER BY aa.create_date desc-->
        ) aa
        <where>
            <if test="params.lastRowNum!=null">
                rownum > ${params.lastRowNum}
            </if>
        </where>
        <if test="params.pageSize!=null">
            LIMIT ${params.pageSize}
        </if>
    </select>