How to delete certain amount of last rows in the table in PostgreSQL?

Question

Without referencing the SERIAL id.

Something like:

delete from users LAST 3

which would delete last 3 rows from the table.

Possible duplicate of How do I delete a fixed number of rows with sorting in PostgreSQL? — Tim Biegeleisen
– Tim Biegeleisen, Commented Mar 25, 2018 at 14:27

Bilal Dekar · Accepted Answer · 2018-03-25 14:54:44Z

11

This will work :

  DELETE
  FROM users 
  WHERE id in (
      SELECT id 
      FROM users 
      ORDER BY id desc
      LIMIT 3
     )

answered Mar 25, 2018 at 14:54

Bilal Dekar

4,1565 gold badges32 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eduard Over a year ago

This uses the id column.

nos Over a year ago

@Eduard Which other column do you have in your table that can track the last/most recent rows you have added to the table ? (Note that postgresql itself does not track this information)

Collectives™ on Stack Overflow

How to delete certain amount of last rows in the table in PostgreSQL?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related