在mysql中使用group by进行分组后取时间最近的一条数据,我们可以直接使用MAX()函数来实现
SELECT
T2.nick_name as nickName,
count(T1.shared_user_id) AS shareNum,
max(T1.insert_dt) as insertDt
FROM
reader_market_sharearnings T1
LEFT JOIN reader_app_user T2 ON T1.profit_user_id = T2.id
WHERE
T1.doc_id = 'specilf8d628b729984c608bfdc1d6500abbb2'
GROUP BY
T1.profit_user_id
ORDER BY
shareNum DESC
结果如下:
添加新时间的数据后也可以正常的查询。