Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

SQL - Remove rows

Back

• SQL - Remove rows
  • DELETE FROM
    • Example

---

DELETE FROM

• remove rows from a table.

-- remove row based on condition
DELETE FROM tb_name
WHERE condition
RETURNING col_1, col_2;

-- remove all records
DELETE FROM tb_name;


-- DELETE JOIN: remove rows based on another tables
DELETE FROM tb_A
USING tb_B
WHERE tb_A.id = tb_B.id;

---

Example

DELETE FROM job
WHERE job_name = 'Student'
RETURNING job_id, job_name;

---

TOP