SqlServer分页查询

Sql sever 分页查询所有

<select id="queryAll" resultMap="user" resultType="com.hzzq.zqrepair.entity.repair.User">
         select top ${limit} * from tbl_user where userid not in
         (
             select top ${start} userid from tbl_user order by userid
         )
         order by userid
</select>

sql sever 分页查询所有以及模糊查询

<select id="queryAll" resultMap="user" resultType="com.hzzq.zqrepair.entity.repair.User">
            select top ${limit} *
            from tbl_user
            <where>
                <if test = "gsmc!=null || lxdh !=null ">gsmc like '%' + #{gsmc}+ '%' and lxdh like '%'+ #{lxdh} +'%'
                    and userid not in
                    (select top ${start} userid from  tbl_user order by userid)
                    order by userid
                </if>
            </where>
            <where>
                <if test = "gsmc==null || lxdh ==null">
                    userid not in
                    (select top ${start} userid from  tbl_user order by userid)
                    order by userid
                </if>
            </where>
</select>