Sunday, October 29, 2023

How to get Top 5 Rows with concatenation ROWNUM and column Values

 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