How to Delete One Row in SQL

To delete a specific row from a table, use the DELETE statement with a WHERE clause that identifies the row uniquely.

Syntax:

DELETE FROM table_nameWHERE condition;

• The condition should uniquely identify the row you want to delete.

Example:

Suppose you have a table employees and want to delete the employee with employee_id = 101:

DELETE FROM employeesWHERE employee_id = 101;

Important:

• Always use a WHERE clause to avoid deleting all rows.

• If the condition matches multiple rows, all those rows will be deleted.

• If you want to delete all rows, use:

DELETE FROM table_name;

If you want me to help with a specific table or condition, just ask!