这是MyBatis配置文件中的一个分页的SQL语句
<select id="selectUsersListByPage" resultMap="BaseResultMap" parameterType="java.util.Map" > select * from ( select top 100 percent *,row_number() over (order by id ) as rn from users_rt <![CDATA[ ) s where rn <= #{end} and rn >= #{start} ]]> </select>
