select * from table b where (select sum(je) from table where cid<=b.cid) <= 65为什么换成:delete from table b where (select sum(je) from table where cid<=b.cid) <= 65就不可以了呢,提示有语法错误请问这句delete 该如何改写才能满足条件,但又不会有语法错误呢,谢谢
调试欢乐多
delete t
from t a
where (select sum(je) from t where cid <=a.cid) <= 65