Question

在mybatis里rownum怎么写

Answer 1

这应该sql语句中增加的 <select id="selectAll" parameterType="java.util.Map" resultType="user">
select * from (select row_.*,rownum rownum_ from (
select b.user_id,b.shremark
from xxxxx b ) row_ where rownum <= #{end}
) WHERE rownum_ >= #{start}
</select>
给你了一个例子。希望能帮到你！