Mybatis分页如何将limit替换成top语句？

源代码

<select id="findAll" parameterType="Map" resultMap="GoodsResult">
    select * from sm_goods 
    <where>
    <if test="name!=null and name!=''">
        and name like "%"#{name}"%"
    </if>
    <if test="type_id!=null and type_id!=''">
        and type_id =#{type_id}
    </if>
    <if test="state!=null">
        and state =#{state}
    </if>
    </where>
    <if test="page!=null and limit!=null">
         limit ${page},${limit}
    </if>
</select>

自己修改过的但没成功的代码

<!-- 查询所有商品 -->
    <select id="findAll" parameterType="Map" resultMap="GoodsResult">
        select * from sm_goods 
        <where>
        <if test="name!=null and name!=''">
            and name like "%"#{name}"%"
        </if>
        <if test="type_id!=null and type_id!=''">
            and type_id =#{type_id}
        </if>
        <if test="state!=null">
            and state =#{state}
        </if>
        </where>
        <if test="page!=null and limit!=null">
            top ${page},${limit}
        </if>
    </select>

现在用的是sqlserver数据库，之前是mysql数据库。所以现在要将limit 换成top