ORACLE数据库做删除操作，
有一张表req_count, 有 apd,name,a,b,c 这5个字段
想要删除表中 a,b,c同时为0情况下得数据，delete语句怎么写
detele req_count from req_count t1 left join (select apd,name,sum(a+b+c) from req_count group by apd,name having sum(a+b+c)=0) t2 on t1.apd=t2.apd and t1.name=t2.name;
我的语句是这么写的，一直报错，显示 ORA-00933:SQL 命令未正确结束
试下这个命令
DELETE FROM req_count WHERE a = 0 AND b = 0 AND c = 0;
同时为0直接 and 把条件拼接起来就可以了啊
detele req_count where a = 0 and b = 0 and c = 0;
delete from req_count r
where r.a = 0
and r.b = 0
and r.c = 0;