87,917
社区成员
发帖
与我相关
我的任务
分享急！！！！请各位大神帮忙！！
请各位大神把下面SQL2012的分页语句改成SQL2008 r2的。。。感谢
<select id="selectPaging" resultMap="BaseResultMap"
parameterType="com.esint.common.query.GenericQueryParam">
select
<include refid="Base_Column_List" />
from T_BAS_SUPPLIER_CERT_CLASS_BIDVALUE
<where>
1 = 1
</where>
<if test="_parameter.getSortParam().size() != 0">
order by
<foreach collection="_parameter.getSortParam()" item="sortParam"
separator=",">
${sortParam.column} ${sortParam.order}
</foreach>
</if>
offset (#{_begin} - 1) row fetch next #{_pagesize} rows only
</select>
<select id="selectPaging" resultMap="BaseResultMap"
parameterType="com.esint.common.query.GenericQueryParam">
select
<include refid="Base_Column_List" />
from T_BAS_SUPPLIER_CERT_CLASS_BIDVALUE
<where>
1 = 1
</where>
<if test="_parameter.getSortParam().size() != 0">
order by
<foreach collection="_parameter.getSortParam()" item="sortParam"
separator=",">
${sortParam.column} ${sortParam.order}
</foreach>
</if>
offset (#{_begin} - 1) row fetch next #{_pagesize} rows only
</select>
...全文
