1.delete from 表名 where ID in (select id from 表名 group by id having count(id) >1)
and rowid not in (select min(rowid) from 表名 group by id having count(id )>1)
posted on 2012-12-05 16:30 透明的魚 閱讀(255) 評論(0) 編輯 收藏
Powered by: BlogJava Copyright © 透明的魚