mysql 查询所有数据 以某个字段不为空,结果不重复,并以它排序 select *, COUNT(distinct userId) from evt_t_pub_audit_msg_report where trim(userId)!='' AND trim(userName)!='' group by userId;