mysql 综合多个字段查询重复的数据
2021-06-17 17:12
0
357
mysql 综合多个字段查询重复的数据
select CONCAT(mid,project_id,createtime) as concatCode ,id from voting_record where deleted_at is null GROUP BY concatCode HAVING count(concatCode) > 1
你还未登录,请登录后留言
select CONCAT(mid,project_id,createtime) as concatCode ,id from voting_record where deleted_at is null GROUP BY concatCode HAVING count(concatCode) > 1