remove row from sql server table code example
Example 1: how to delete row in sql
DELETE FROM my_table; -- all rows
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);
Example 2: sql server delete row
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