<select id="getTopThreeKeyWord" resultMap="BaseResultMap">
SELECT a.* FROM precise_match_keyword a WHERE 3 >
(SELECT COUNT(*) FROM precise_match_keyword WHERE CLASS_CODE = a.CLASS_CODE AND USE_NUM > a.USE_NUM )
ORDER BY a.CLASS_CODE DESC ,a.USE_NUM DESC
</select>
先分组 再得到组内前top3数据--------------------mysql
最新推荐文章于 2021-03-17 08:36:41 发布