熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

oracle刪除重復行

2013-11-13 22:19:23  來源: 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
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.