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