Cloud Training (Online)




SQL Server 101 – How to Delete Top N records ?

Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top 1000 rows from the table. You can use the SQL Query with the TOP (N) as option as shown below. Here’s N is the number of records that you want to delete.

How to Delete Top N records in MS SQL Server ?

DELETE TOP (1000)
FROM Employee
WHERE IsMarkedForDelete = 1

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.