delete from testp
where id in
( select id
from
(
select id, row_number() over (
partition by name order by created_on desc ) rn
from testp)
where rn > 5
)
假设:
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句