sql查询重复数据只保留一条 sql重复数据只显示一条 并且统计重复次数

sql 怎么删除重复数据只保留一条？ with cte as(select*，row_number()over(partition by rectime order by id)rn from tb)delete cte where rn&...