4. SQL Statements : DELETE : DELETE Examples
 
Share this page                  
DELETE Examples
1. Delete from the sales_fact table where the year is last year:
CREATE TABLE sales_fact (
    sales_date ANSIDATE,
    value INTEGER2,
    quantity FLOAT8);
INSERT INTO sales_fact VALUES ('2013-02-28', 120, 23.8),('2014-04-30', 1, 3.8),('2012-08-14', 30, 44.0),('2013-11-01', 1, 19.4),('2012-10-12', 3, 14.4);
DELETE FROM sales_fact WHERE year(sales_date) = year(CURRENT_DATE);
One row will be deleted.
2. Delete all rows from sales_fact:
DELETE FROM sales_fact;