根据用户id 分组 取最近的一条(id最大),一定要加 limit 不然不起作用
SELECT
a.user_id,
a.id
FROM
( SELECT user_id, id, mobile FROM new_member_step_record ORDER BY id DESC LIMIT 100000 ) AS a
GROUP BY
user_id
ORDER BY
id DESC
根据用户id 分组 取最近的一条(id最大),一定要加 limit 不然不起作用
SELECT
a.user_id,
a.id
FROM
( SELECT user_id, id, mobile FROM new_member_step_record ORDER BY id DESC LIMIT 100000 ) AS a
GROUP BY
user_id
ORDER BY
id DESC