Mybatis中选择语句的使用：＜choose＞标签、分区排序 Row_num() over ()函数的使用呢

<select id="seleDateByCase" resultMap="BaseResultMap" parameterType="java.lang.String">
    select <include refid="Base_Column_List" />
    from litemall_signin_record lsu
    <where>
      <choose>
        <when test="type == 1">
          lsu.signin_num_get &lt; 0
        </when>
        <when test="type == 2">
          lsu.signin_num_get &gt; 0
        </when>
      </choose>
      and user_id = #{userId}
      order by lsu.update_time desc
    </where>
 
  </select>