mysql先排序后group by
取出所有最近的登录日志,相同的用户登录日志只取最新的一条。
mysql语句:
注意:
1.mysql 5.7 以上子查询 groupBy要加limit 限制
2.主语句不能加where条件
SELECT `user_id`, `id`, `login_time` FROM ( SELECT * FROM `bl_user_login_log` WHERE (( `sid` = '1001' )
AND ( `delete_status` = 0 ))
AND ( `login_port` = 'admin' )
ORDER BY
`login_time` DESC
LIMIT 4294967295
) `log`
GROUP BY
`log`.`user_id`
ORDER BY
`login_time` DESC
返回结果:
参考资料: