sql server数据库,去除数据库表中重复的数据
DELETE LU
FROM (SELECT *,
Row_number()
OVER (
partition BY stcd ,reporttime ,tm
ORDER BY tm DESC) [Row]
FROM ST_PREAL) LU
WHERE [row] > 1
sql server数据库,去除数据库表中重复的数据
最新推荐文章于 2024-09-09 09:23:14 发布
sql server数据库,去除数据库表中重复的数据
DELETE LU
FROM (SELECT *,
Row_number()
OVER (
partition BY stcd ,reporttime ,tm
ORDER BY tm DESC) [Row]
FROM ST_PREAL) LU
WHERE [row] > 1