ORACLE数据库做删除操作

Question

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 命令未正确结束

Answer 1

试下这个命令

DELETE FROM req_count WHERE a = 0 AND b = 0 AND c = 0;