If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query:
DELETE FROM MyTable
WHERE PK_Column
IN(
SELECT TOP 100 PK_Column
FROM MyTable
ORDER BY creation
)
Why Would You Require To Delete Top 100 Records?
I often delete a top n records of a table when number of rows in the are too huge. Lets say if I’ve 1000000000 records in a table, deleting 10000 rows at a time in a loop is faster than trying to delete all the 1000000000 at a time.
What ever may be reason, if you ever come across a requirement of deleting a bunch of rows at a time, this query will be helpful to you.