1,2,2,4排名
SELECT rank() over(ORDER BY SCORE DESC) SORT,t.* FROM "CARRIER_GRADE" t WHERE MONTH='2023年06月'
1,2,2,3排名
SELECT dense_rank() over(ORDER BY SCORE DESC) SORT,t.* FROM "CARRIER_GRADE" t WHERE MONTH='2023年06月'
实际执行
SELECT
*
FROM
(
SELECT
dense_rank ( ) over ( ORDER BY SCORE DESC ) sort,
t.*
FROM
"CARRIER_GRADE" t
WHERE
MONTH = #{reqVO.month}
ORDER BY
sort ASC,
CARRIER_CODE ASC
)
<where>
<if test="reqVO.carrierName!=null and reqVO.carrierName!=''">
and (CARRIER_CODE LIKE CONCAT(CONCAT('%',#{reqVO.carrierName}),'%') or
CARRIER_NAME LIKE CONCAT(CONCAT('%',#{reqVO.carrierName}),'%'))
</if>
</where>
参考
https://www.dbs724.com/145830.html