摘要： 许久不用，又忘了，做个记录 update test b set b.val=(with t as(select t.id,val||'_'||row_number() over(partition by val order by id) t1from test t)select a.val from 阅读全文