On 5/17/05, The Human Fly <sjaffarhussain_at_gmail.com> wrote:
> > Good Day everyone!> > We have one online table which gets a lot of insertions every second> and there could no insertions sometimes, This table has one timestamp> column which stores timestamp when an inserts take places.> My requirements is, say there are insertions at 10:10:10 AM and the> next insertion is at 10:11:10AM, i.e. there are no transactions take> place from 10:10 to :10:11 am. When I use normal query which only> display records which are exists for the stored timestamp.> Is it possible that I write a query which see the next record and> between timestamp is not 1 second says, no rocrd in this second.> > Thanking you in advance for your valuable time.> --=20> Best Regards,> Jaffar, OCP DBA> Banque Saudi Fransi>