且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

删除 SQL 中的每个交替行

更新时间: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