MSSQLServer2008R2里面的刪除語句問題?
with test as(select id=row_number()over(partition by CNBMC order by CNBMC),* from tablename where CNBMC in('BLSH_1000','blsh_1001'))delete test where id=2
MSSQLServer2008R2里面的刪除語句問題?
with test as(select id=row_number()over(partition by CNBMC order by CNBMC),* from tablename where CNBMC in('BLSH_1000','blsh_1001'))delete test where id=2