mysql查询相同的记录(多字段)

查询出 user 表中 name，qq，mobile 都相同的记录
SELECT * FROM user a WHERE (a.name,a.qq,a.mobile) in (SELECT name,qq,mobile FROM user GROUP BY name,qq,mobile HAVING count(*) > 1)