Hello,
Create Table T1_TEMP(ID number, YEAR number, CASES varchar2(10), count number);
insert into T1_TEMP values (1232, 2015,'14-A786',7);
insert into T1_TEMP values (1232, 2016,'13-5767',7);
insert into T1_TEMP values (1232, 2016,'12-G674',7);
insert into T1_TEMP values (1232, 2017,'17-6YG4',7);
insert into T1_TEMP values (1232, 2018,'11-07A5',7);
insert into T1_TEMP values (1232, 2018,'03-1A55',7);
insert into T1_TEMP values (1232, 2018,'03-17A1',7);
insert into T1_TEMP values (1232, 2019,'02-519A',7);
insert into T1_TEMP values (1232, 2020,'07-A594',7);
insert into T1_TEMP values (1232, 2020,'09-A976',7);
insert into T1_TEMP values (1232, 2020,'10-781I',7);
I have data in this format:
I need to combine the fields YEAR and CASES into one column and have a <DIV> tag for each year. My expected data format is:
Is that doable? I am looking to get just one row for each ID. Greatly appreciate any help.
Thank You.