oracle分页语句
<select id="queryDefinedUserGroup" parameterType="java.util.Map"
resultType="com.huawei.iop.bean.TaskInfo">
select c.* from(
select t.*,rownum rm from(
select
groupID,
groupName,
groupDescribe,
status,
userNum,
downloadPath,
from
DIM_WORLDCUP_DEFINED_TASK
where 1=1
<if test="groupName != null and groupName != ''">
and groupName = #{groupName}
</if>
)t
where rownum <= #{end}) c
where rm >= #{start}
</select>

浙公网安备 33010602011771号