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