SELECT
*
FROM
(
SELECT
*
FROM
M_UP_EVENT
LEFT JOIN WF_FILE ON M_UP_EVENT.EVENT_ID = WF_FILE.WFR_ID
AND WFS_FIELD_NAME = 'EVENT_IMG'
AND FILE_STATUS = 'Y'
AND WF_FILE.WF_MAIN_ID = '51117'
WHERE 1=1
AND EVENT_ID != 343
ORDER BY M_UP_EVENT.EVENT_ID DESC
)
WHERE
ROWNUM <= 4 Error Description: ERROR: column "rownum" does not exist
LINE 18: ROWNUM <= 4
^