oracle刪除重復行

　　delete from subs b where browid<(select max(arowid) from subs a where amsid=bmsid and ams_type=bms_type and aareacode=bareacode);

From:http://tw.wingwit.com/Article/program/Oracle/201311/18768.html