Search This Blog

Friday, January 17, 2014

how to delete top n records using sql delete statement?

DELETE top (n) FROM Table1
Note : This statement will work in sql server 2005 and above but for below version use following sql statement

DELETE tbl FROM (Select Top n * FROM Table1 ) tbl

No comments:

Post a Comment