SELECT max ( c_visittime ) , c_ip , c_id
FROM `t_vistor`
GROUP BY c_ip
ORDER BY max ( c_visittime ) DESC
LIMIT 0 , 30
mysql的去重查询整条记录
最新推荐文章于 2024-04-17 15:25:46 发布
SELECT max ( c_visittime ) , c_ip , c_id
FROM `t_vistor`
GROUP BY c_ip
ORDER BY max ( c_visittime ) DESC
LIMIT 0 , 30