查询一个表内相同纪录 无 select?*?from?表?where?id?in?(select?id?from?表?group?by?id?having?sum(1)1) select?*?from?表?where?id1+id2+id3?in(select?id1+id2+id3?from?表?group?by?id1,id2,id3?having?sum(1)1) --方法1：select*fromzy_bhoa
查询一个表内相同纪录
select?*?from?表?where?id?in?(select?id?from?表?group?by?id?having?sum(1)>1)
select?*?from?表?where?id1+id2+id3?in(select?id1+id2+id3?from?表?group?by?id1,id2,id3?having?sum(1)>1)
--方法1：select*fromzy_bhoawhereexists?(select1fromzy_bhowhere[pk]a.[pk]andzyh=a.zyh)??--方法2：selecta.*fromzy_bhoajoinzy_bhob?on(a.[pk]b.[pk]anda.zyh=b.zyh)??--方法3：select*fromzy_bbowherezyhin?(selectzyhfromzy_bbogroupbyzyhhavingcount(zyh)>1)?--其中pk是主键或是?unique的字段。