Question

mybatis里面我要动态查询表的前n行数据：SELECT * FROM aa FETCH FIRST #{NUM} ROWS ONLY的#{NUM} 怎么写

<select id="getAllClueVerifyCgtPage" parameterType="map" resultType="map" >
SELECT *
FROM aa
<if test="NUM != null">
FETCH FIRST #{NUM} ROWS ONLY
</if>

</select>

Answer 1

SELECT *
FROM aa
<if test="NUM != null">
FETCH FIRST ${NUM} ROWS ONLY

这样就可以了，我在项目也这样处理的