Display Multiple Rows to Single Row

Display Multiple Rows to Single Row



Use below query model to display Multiple Rows to Single Row


(SELECT LISTAGG(TO_CHAR(creation_date,'DD-MON-RR HH24:MI:SS'), ',') WITHIN GROUP (
ORDER BY creation_date DESC)
FROM WIP_EAM_WORK_REQ_NOTES
WHERE work_request_id     =21167
AND work_request_note_type=1
AND notes NOT LIKE '*%'
AND notes NOT LIKE '@%'
AND notes NOT LIKE ' %'
GROUP BY work_request_id
)FOLLOW_UP_DATE

Post a Comment

0 Comments