Answer: How to delete the top 1000 rows from a table using Sql Server 2008?

answer re: How to delete the top 1000 rows from a table using Sql Server 2008?

Jan 21 '12

195

The code you tried is in fact two statements. A DELETE followed by a SELECT.

You don't define TOP as ordered by what.

For a specific ordering criteria deleting from a CTE or similar table expression is the most efficient way.

;WITH CTE AS

(

SELECT TOP 1000 *

…

Open Full Answer

Delete TOP N Rows in sql