刪除重復(fù)的記錄,并保存第一條記錄或保存最后一條記錄
刪除表:dgpage中Mail重復(fù)的記錄并保留最后一條.
delete dgpage where id in ( select a.id from dgpage a, dgpage b where a.mail = b.mail and a.id > b.id )
刪除表:dgpage中Mail重復(fù)的記錄并保留最近一條.
delete dgpage where id in ( select a.id from dgpage a, dgpage b where a.mail = b.mail and a.id
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
