Press Release

SQL1:SELECT * FROM ( SELECT OU_ENEWS_ID, OU_SCHOOL, OU_WCSDT_DIS, OU_IMG_URLENG, OU_TITLE_ENG, OU_EXT_LINK, OU_ENEWS_YR, OU_ENEWS_MTH, OU_ENEWS_DD, ' ' AS OU_DESC2, LANG_SUPP, SEQNUM FROM sysadm.PS_OU_ENEWS_PRD WHERE OU_INACTIVE <> 'Y' and OU_ENEWS_CAT = 'PR' AND (OU_ENEWS_YR >= TO_NUMBER(TO_CHAR(sysdate, 'YYYY'), '9999')) ORDER BY OU_ENEWS_YR DESC, OU_ENEWS_MTH DESC, OU_SCHOOL, OU_ENEWS_DD DESC, SEQNUM DESC )TBL WHERE ROWNUM < 500