Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

create table corce (aa int);

insert into corce values('90');

insert into corce values('90');

insert into corce values('90');

 

利用group by 查出重複的質有哪些 再刪除

*****************

 

select aa,count(1) from corce
group by aa having count(1)>1;

******************

 

 

利用rowid 進行刪除

******************

DELETE FROM corce E WHERE E.ROWID > 
(SELECT min(X.ROWID) FROM corce X WHERE X.corce = E.corce);

******************

最後只會留下一筆 aa=90;