How To Delete Top 100 Rows From SQL Server Tables

If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query:

    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.

Leave a Comment

Your email address will not be published. Required fields are marked *