02 2012 档案

Oracle 删除重复数据只留一条
摘要：DELETEfrom表WHERE(id)IN(SELECTidFROM表GROUPBYidHAVINGCOUNT(*)>1)ANDROWIDNOTIN(SELECTMIN(ROWID)FROM表GROUPBYidHAVINGCOUNT(*)>1); 阅读全文
posted @ 2012-02-15 18:41 青春岁月,无怨无悔 阅读(240) 评论(0) 推荐(0)