Mybatis中选择语句的使用:<choose>标签、分区排序 Row_num() over ()函数的使用呢
1、Mybatis中数据库语句的选择 使用:
<choose>
<when test="relationType=='L'">
<choose>
<when test="pe=='EX">
= c.code
</when>
<otherwise >
=c.ex
</otherwise>
</choose>
</when>
<otherwise >
= c.delive
</otherwise>
</choose>
2、分区排序
Row_num() over ():
ROW_NUMBER() OVER (PARTITION BY V.CODE ORDER BY V.MODIFYTIME) ROW_NUM