oracle相同数据将一般数据改成不同月份

Question

有一张表 数据结构如下

想把相同数据的sj字段改成202204和202203，只在原来的基础上把重复的那条数据修改一下，
想要修改成这种效果

应该怎么写sql
表结构我放在评论区

Answer 1

create table q (id varchar2(50), name varchar2(50),fs number,sj varchar2(50));
insert into q values(1,'jame',60,'202204');
insert into q values(1,'jame',60,'202204');
insert into q values(2,'niko',70,'202204');
insert into q values(2,'niko',70,'202204');
insert into q values (3,'bit',80,'202204');
insert into q values (3,'bit',80,'202204');
insert into q values(4,'ropz',75,'202204');
insert into q values(4,'ropz',75,'202204');
insert into q values(5,'rain',90,'202204');
insert into q values(5,'rain',90,'202204');
select * from q;