我有一张桌子,
--------------
|id descrip |
|1 A |
|2 B |
|3 C |
|3 D |
|3 E |
|4 F |
|4 F |
我的预期输出是:
--------------
|id descrip |
|1 A |
|2 B |
|3C C |
|3D D |
|3E E |
|4 F |
|4 F |
我尝试使用第一种方法:
merge into rules_table a
using rules_table b
on (a.id = b.id and a.descrip and a.rowid > b.rowid)
when matched then
update set a.id = b.id || b.descrip
我尝试的第二种方法是:
update rules_table a
set a.id =
(select b.id || b.descrip
from rules_table b
where b.id = a.id
and b.descrip = a.descrip
and a.rowid = b.rowid)
但是,我没有得到想要的输出。