当前位置: 代码迷 >> Sql Server >> 怎样改写delete from select * from table解决方法
  详细解决方案

怎样改写delete from select * from table解决方法

热度:145   发布时间:2016-04-27 19:37:22.0
怎样改写delete from select * from table
delete   from   select   *   from   table  
这样写无法执行,请问怎样改写.

------解决方案--------------------
delete table where ?? not in (select ?? from table))

delete table where ?? in (select ?? from table))

------解决方案--------------------
delete a from a, b where ???
------解决方案--------------------
delete from a where ?
  相关解决方案