DEV Community

loading...

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

boyukbas profile image baris ใƒป1 min read

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 *
โ€ฆ






Delete TOP N Rows in sql

Discussion (0)

pic
Editor guide