sql 怎么删除重复数据只保留一条？ with cte as(select*，row_number()over(partition by rectime order by id)rn from tb)delete cte where rn>；1
sql删除重复数据只保留一条 delete from t_prices_jg where fid not in(select min(fid)from t_prices_jg group by fitemcode，foper，fsb)这样就行了啊，备份一下表执行
SQL删除重复数据保留一条 delete table where id-标识列-not in(select min(id)from table group by Jnum，Wnum)
