JavaScript
急！！！！请各位大神帮忙！！
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区请各位大神把下面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>
...全文
