[GENERAL] Delete from table conditionally

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема [GENERAL] Delete from table conditionally
Дата
Msg-id 1586512452.4798452.1481960368113@mail.yahoo.com
обсуждение исходный текст
Ответы Re: [GENERAL] Delete from table conditionally
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: [GENERAL] Re: [GENERAL] Love Your Database project — Thoughts on effectively handling constraints?
Следующее
От: "Charles Clavadetscher"
Дата:
Сообщение: Re: [GENERAL] Delete from table conditionally