Question

删除符合SQL查询要求的元组，语句怎么写

哎，无语了，刚发完问题就想起来了。刚刚大脑比较迟钝

Answer 1

delete from 表名 where 条件

Answer 2

呵呵，有时候人就会这样．突然性失忆．．．

Answer 3

...
delete
from db.dbo.ab
from db.dbo.ab a
inner join
(select COUNT(PK)as NUM,A,B,C
from db.dbo.ab
group by A,B,C
having NUM>C)b
on a.A=b.A and a.B=b.B and a.C=b.C

Answer 4

delete from 表 Where 条件