delete row m sql code example

Example 1: how to delete row in sql

delete from TableName where condition;
delete from scrumteam where firstname='Jack';
delete from scrumteam where JobTitle='SDET';

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