DELETE FROM my_table WHERE id = 3;
DELETE FROM my_table; -- All rows
DELETE TOP 10 FROM my_table; -- First 10 rows
DELETE TOP 10 PERCENT FROM my_table; -- First 10% of rows
Delete from table1
Where Coloumn1 =134
DELETE FROM salesTransaction
Where trx_id=1249
1
2
Delete from Person.Person
Where BusinessEntityID=1
1
Delete from Person.Person