MySQL 对一个字段去重,保留其他字段

--参与人数:
SELECT count(mobile), FROM_UNIXTIME( time, '%Y年%m月%d' ) t FROM member WHERE id IN ( SELECT max( id ) FROM member GROUP BY mobile ) GROUP BY t
--参与人清单
SELECT mobile,FROM_UNIXTIME(time,'%Y年%m月%d') t FROM member WHERE id IN ( SELECT max( id ) FROM member GROUP BY mobile );

本作品采用《CC 协议》，转载必须注明作者和本文链接