UPDATE CRMOLOG SET TMS_YN = 'P' WHERE TMS_YN = 'N' AND
TR_SQNO IN

(SELECT TR_SQNO FROM( SELECT TR_SQNO FROM CRMOLOG WHERE TMS_YN = 'N' ORDER BY TR_SQNO ASC) WHERE ROWNUM < 20001)

Oracle 구문입니다..

Informix 용 구문으로 바굴려는데...안되네여

도와주세요