Deleting rows with time 55 minutes less than max time

From: "Imtiaz(dot) S(dot) M" <imtiaz_sm(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Deleting rows with time 55 minutes less than max time
Date: 1999-11-19 11:07:21
Message-ID: 38352F68.FB6DDC78@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a table which contains a single datetime column along with other
columns. Now I want to delete all the rows with datetime values 55
minutes less(in the datetime column) than the maximum datetime value
present in the datetime column. How do I achieve this? I have tried all
possibile methods which I know of. Still could not achieve this.
Thanks in advance.

regards
Imitaz

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Joyce 1999-11-19 14:22:24 selecting from indexes
Previous Message Haris Susanto 1999-11-19 07:24:06 Backend message type 0x45 arrived while idle