delete rows psql code example

Example 1: delete entries in postgresql

DELETE FROM table WHERE condition;

Example 2: delete all entries postgres

DELETE FROM tablename;

Example 3: delete row psql

DELETE FROM table
WHERE condition;

Example 4: delete from select postgresql

DELETE FROM mytable 
WHERE ctid IN (
    SELECT ctid
    FROM mytable 
    GROUP BY s.serialId, s.valuetimestamp
    ORDER BY s.serialId
    LIMIT 10
)

Tags:

Sql Example

Related