示例:
SELECT * FROM
(SELECT
*
FROM
t_anchor_proportion d
ORDER BY d.`updateTime` DESC
LIMIT 1000) f
GROUP BY f.userId;
备注:mysql5.7以后需要加limit排序才生效,不然排序无效果
示例:
SELECT * FROM
(SELECT
*
FROM
t_anchor_proportion d
ORDER BY d.`updateTime` DESC
LIMIT 1000) f
GROUP BY f.userId;
备注:mysql5.7以后需要加limit排序才生效,不然排序无效果