ORACLE ??
-
编辑 删除
刪除重復紀錄的兩種方法！
方法一delete from i a where a.rowid<(select max(rowid) from i b where a.no=b.no)方法二delete from i where rowid in (select rowid from (select no,row_number()over(partition by no order by no) rn from i...
