Thread: [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? Regards, Arup Rakshit
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