🗑️ DELETE Command in SQL

Last Updated: January 2026

The DELETE command is used to remove existing records (rows) from a table.

  • Deletes one row, multiple rows, or all rows
  • Works row by row
  • Can be rolled back (if transaction supported)

Hinglish Tip 🗣: Table se data hatana ho → DELETE.

🧾 Basic DELETE Syntax

DELETE FROM table_name;

Warning: ⚠️ This deletes all rows from the table.

✅ Safe DELETE (With WHERE)

DELETE FROM employees
WHERE emp_id = 101;

✔ Deletes only one specific row

🔄 DELETE Multiple Row

DELETE FROM students
WHERE marks < 40;

🔄 DELETE Using Another Table

DELETE FROM orders
WHERE customer_id IN (
  SELECT customer_id
  FROM customers
  WHERE status = 'Inactive'
);
← PreviousNext →