ssms - 如何在SQL中按行号删除

Question

我需要从第 475 行到 948 行删除，因为它们是第 1-474 行的重复项。我想这将是接近于此的东西，或者还有更多吗？

DELETE FROM dbo.industry WHERE row_number between 475 and 948

Answer 1

可能为时已晚，但我通常这样做

; with cte(rownum)as(
    select row_number () over(partition by [Col1], [Col2] order by Col3) from [table]
)
delete from cte where rownum > 1