By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name (Requisition_number, per_id, per_name, Job_title, Interview, TAS_EMAIL_ADDRESS, TAS_FNAME) AS
SELECT 22021, 1097, 'Chad', 'Manager', 'This is a comment', 'abc.g@gmail.COM', 'abc' FROM DUAL UNION ALL
SELECT 22021, 1097, 'Chad', 'Manager', 'This is a comment', 'xyz.g@gmail.COM', 'xyz' FROM DUAL;
2 rows affected
SELECT Requisition_number,
per_id,
per_name,
Job_title,
Interview,
TAS_EMAIL_ADDRESS,
CASE ROW_NUMBER()
OVER (
PARTITION BY Requisition_number,
per_id,
per_name,
Job_title,
Interview
ORDER BY tas_fname
)
WHEN 1
THEN LISTAGG(tas_fname, '/') WITHIN GROUP (ORDER BY tas_fname)
OVER (
PARTITION BY Requisition_number,
per_id,
per_name,
Job_title,
Interview
)
END AS tas_fname
FROM table_name
| REQUISITION_NUMBER | PER_ID | PER_NAME | JOB_TITLE | INTERVIEW | TAS_EMAIL_ADDRESS | TAS_FNAME |
|---|---|---|---|---|---|---|
| 22021 | 1097 | Chad | Manager | This is a comment | abc.g@gmail.COM | abc/xyz |
| 22021 | 1097 | Chad | Manager | This is a comment | xyz.g@gmail.COM | null |