IT Solutions
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment