<select id="getOutAndPutTable" resultType="com.ustcsoft.jt.vo.grainReserves.AccountVO" parameterType="java.lang.String">
SELECT
Top (cast( #{number} as int))
id AS 'id',
FROM
td_warehousestoredetail
<if test="number1>=0">
AND w.id NOT IN (
SELECT
Top (cast( #{number1} as int))
w.id AS 'id'
FROM
td_warehousestoredetail
ORDER BY w.id
)
</if>
ORDER BY w.id
</select>
sql server 的top 分页问题
最新推荐文章于 2024-02-17 11:39:18 发布