DELETE语句一条DELETE语句

时间:2021-03-17 人气:0

想了解一条DELETE语句的相关内容吗，在本文为您仔细讲解DELETE语句的相关知识和一些Code实例，欢迎阅读和指正，我们先划重点：DELETE,语句，下面大家一起来学习吧。

WITH w AS(
SELECT Id,ROW_NUMBER() OVER(ORDER BY Id DESC) AS [Row]
FROM [t1]
WHERE Code=@Code
)
DELETE FROM t1 FROM t1 s INNER JOIN w ON s.Id=w.Id
WHERE w.Row>100;