ITPub博客

--删除rn不等于1的rowid所在行的记录delete from fhx_db_time t2 where t2.rowid in(select t1.rid from (--使用row_number() over(partition by XX order by XX)函数对重复数据加标识select fdt.*,row_number()over (partition by dbuid ,end_interval_time order by dbuid) rn ,rowid rid from fhx...