删除TXMA(条形码)和GLBHAO(关联编号)两个列数值都相同的数据,前提是ID是主键:
delete from B_KC_WLKCMXI where [ID] in (select max([ID]) from B_KC_WLKCMXI group by TXMA,GLBHAO
having count(*)>1)
删除GLBHAO(关联编号)一列数值相同的语句也是同理:
delete from B_KC_WLKCMXI where [ID] in (select max([ID]) from B_KC_WLKCMXI group by GLBHAO
having count(*)>1)