更新时间:2021-12-31 22:26:57
如果您使用的是 SQL Server 2005 或更高版本,您可以执行类似的操作.
If you are on SQL Server 2005 or later you can do something like this.
delete T
from (
select row_number() over(order by [Timestamp]) as rn
from YourTable
where SomeColumn = @SomeValue
) T
where T.rn % 2 = 0