update CVSUSROBJRELTAB set CHRGFLG=1 where (GAGEOBJID,USRNM ) in ( SELECT GAGEOBJID,min(USRNM) from CVSUSROBJRELTAB where GAGEOBJID in ( SELECT GAGEOBJID from CVSUSROBJRELTAB group by GAGEOBJID having sum(decode (CHRGFLG,1,1,0))=0) group by GAGEOBJID)
select * from CBSUSROBJRELTAB WHERE (GAGEOBJID,USRNM ) IN ( SELECT GAGEOBJID,MAX(USRNM) M_USRNM FROM TB WHERE CHRGFLG<>1 GROUP BY GAGEOBJID ) 先查询下,再update
SELECT GAGEOBJID,min(USRNM) from CVSUSROBJRELTAB where GAGEOBJID in (
SELECT GAGEOBJID from CVSUSROBJRELTAB group by GAGEOBJID having sum(decode (CHRGFLG,1,1,0))=0)
group by GAGEOBJID)
CBSUSROBJRELTAB
WHERE (GAGEOBJID,USRNM ) IN
(
SELECT GAGEOBJID,MAX(USRNM) M_USRNM FROM TB WHERE CHRGFLG<>1
GROUP BY GAGEOBJID
)
先查询下,再update