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
0 Comments