🗑️ 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.

$\checkmark$ Safe DELETE (With WHERE)

DELETE FROM employees
WHERE emp_id = 101;

$\checkmark$ 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'
);

Liked This Tutorial

Scan QR Code To Leave A Review Or

Click Here To Leave A Review