Hi
I have the following data
Expected result is
CREATE TABLE sample_data(
ID INTEGER NOT NULL
,G_NAME VARCHAR(13) NOT NULL
,SG_NAME VARCHAR(51) NOT NULL
);
INSERT INTO sample_data(ID,G_NAME,SG_NAME) VALUES (1101,'RGS-Frontline','zransons');
INSERT INTO sample_data(ID,G_NAME,SG_NAME) VALUES (1101,'RGS-Frontline','yhtaylo2,pwillis');
INSERT INTO sample_data(ID,G_NAME,SG_NAME) VALUES (1101,'RCS-SSA','axrimars,yjanarxh,gvz,jghgrtzi,jgkixx,szowgr,sygill');