delete from bsp.receive where rowid in(select a.rowid from bsp.receive a, bsp.receive b where a.rowid>b.rowid and a.PONO=B.PONO and a.LINENO=b.LINENO and a.AUTONO=b.AUTONO )在ODAC里用这个查询总是报SELECT语句缺少了KEYWORD
调试欢乐多
begin
delete from bsp.receive where rowid in(select a.rowid from bsp.receive a, bsp.receive b where a.rowid>b.rowid and a.PONO=B.PONO and a.LINENO=b.LINENO and a.AUTONO=b.AUTONO ) ;
end;