Upcoming Events
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_ETITLE IS NOT NUll
ORDER BY M_UP_EVENT.EVENT_ID DESC
)
WHERE ROWNUM <= 3Error Description: ERROR: column "rownum" does not exist
LINE 11: WHERE ROWNUM <= 3
^