SELECT (ROWNUM || '.' || DESCRIPTIONS) Note_Status , APPOINT_WITH,call_date
FROM (SELECT C.DESCRIPTIONS,
c.APPOINT_WITH,
c.call_date
-- RANK () OVER (ORDER BY ROWNUM DESC) MY_RANK
FROM CRM_TRNS_LOG C
WHERE C.CONTACT_ID = :P20_CONTACT_ID AND LOG_NO = 3
ORDER BY CRM_TRNS_LG_NO DESC
FETCH NEXT 5 ROWS ONLY)
No comments:
Post a Comment