Sponser Link

SQL Server delete rows

You can delete the existing data using DELETE statement. Using WHERE clause you can remove one or more rows in table. Syntax is given below.

Delete from table1
Where Coloumn1 =134

You can write your expression for delete more rows. For example WHERE dt BETWEEN '2022-01-01' AND '2022-01-31'. Example is given below.

DELETE FROM SalesTransaction
Where Trx_id=1249