HAVING(COUNT(*)＞1)查重复数据，根据时间取最新字段sql

SELECT ua.user_id,COUNT() FROM user ua GROUP BY ua.user_id

HAVING(COUNT()>1)
拼接条件

完整sql
SELECT ua.user_id,COUNT() FROM user_archives ua GROUP BY ua.user_id HAVING(COUNT()>1)

关于max（时间字段）取最新一条数据

SELECT u.*,MAX(u.`create_time`) FROM`user_action` u GROUP BY u.`user_info_id`  ORDER BY u.`create_time` DESC 

SELECT u.* FROM`user` u GROUP BY u.`user_info_id`
HAVING (MAX(u.`create_time`))  ORDER BY u.`create_time` DESC