Thread: [GENERAL] Delete from table conditionally

[GENERAL] Delete from table conditionally

From
Arup Rakshit
Date:
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? 


Regards,
Arup Rakshit


Re: [GENERAL] Delete from table conditionally

From
"Charles Clavadetscher"
Date:
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