如图,需要根据user_id进行分组,最新的数据优先于分组,结合limit:
相关sql:
SELECT
a.id,
a.user_id,
a.user_name,
a.create_time,
a.remark
FROM
`itd_authentication_qqwx_log` a
INNER JOIN (
SELECT
Max(id) id
FROM
itd_authentication_qqwx_log
WHERE
(`authentication_type` = 1)
AND (`check_status` = 1)
GROUP BY
user_id
) b ON a.id = b.id
ORDER BY a.id desc
LIMIT 0,15
;