Delete from table conditionally

Hello

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Arup Rakshit
Sent: Samstag, 17. Dezember 2016 08:39
To: Pgsql-general <pgsql-general@postgresql.org>
Subject: [GENERAL] Delete from table conditionally

Hi,

I am using Postgresql 9.5.

Below is the sample data taken from the mail table with only required columns:

id | question_id | answer_id | content
----+-------------+-----------+----------
2 | 25 | 270 | Arup
3 | 26 | 276 | Kajal
4 | 26 | 276 | Arup
5 | 27 | 280 | Kajal
6 | 25 | 270 | Arup
7 | 25 | 270 | Lalu
8 | 25 | 270 | Arup
9 | 26 | 274 | Dilip
10 | 25 | 270 | doli
11 | 25 | 270 | Arup
(10 rows)

Say, I know the id 6 where content is "Arup". Now from this row, I want to delete all next rows where the content is
"Arup". How should I achieve this?

Assuming that "next" means id > 6:

DELETE FROM <tablename>
WHERE id > 6
AND content = 'Arup';

Regards
Charles

Regards,
Arup Rakshit

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general