å®ç°æ¹å¼å¦ä¸ï¼
Dim cnn As Object, rs As Object, SQL$, i&, s$1ãå é¤å
¨é¨éå¤è®°å½ï¼æ
ç¨ï¼
Delete 表 Where éå¤å段 In (Select éå¤å段 From 表 Group By éå¤å段 Having Count(*)>1)
2ãä¿çä¸æ¡ï¼è¿ä¸ªåºè¯¥æ¯å¤§å¤æ°äººæéè¦ç ^_^ï¼
Delete HZT Where ID Not In (Select Max(ID) From HZT Group By Title)
注ï¼æ¤å¤ä¿çIDæ大ä¸æ¡è®°å½
3ãæ¥æ¾è¡¨ä¸å¤ä½çéå¤è®°å½ï¼å¤ä¸ªå段ï¼
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
4ãå é¤è¡¨ä¸å¤ä½çéå¤è®°å½ï¼å¤ä¸ªå段ï¼ï¼åªçærowidæå°çè®°å½
delete from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)