请教个语句我怎么找出mysql中,除自动增长的那个ID外,其他字段完全重复的记录SELECT id, g_id, time, info, count( * ) AS num
FROM `oa_guest_contact_record`
GROUP BY time
HAVING num >1我如何在这个语句中价格g_id和info也相等的条件
FROM `oa_guest_contact_record`
GROUP BY time
HAVING num >1我如何在这个语句中价格g_id和info也相等的条件
where exists
(select 1 from oa_guest_contact_record
where g_id=t1.g_id and time=t1.time and info=t1.info and id!=t1.id)
FROM `oa_guest_contact_record`
GROUP BY time,g_id,info
HAVING num >1