Re: query help wanted

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/07/10
Message-ID: <5q1fs0$bm$1@marri.bs.wa.gov.au>#1/1

You are assuming that these records are going to be retrieved in order of recency. This is not a good idea. You should be using a date or a sequence column to decide which records are newest. Sandeep Deshmukh wrote in article <5pugrn$b4i_at_news.informix.com>...
>Ok I figured one out:
>
>delete from atab where custid = <blah> and
>rownum < (select (max(rownum) -200) from atab where custid = <blah>);
>
>Any others?
>/sandeep
>
>
Received on Thu Jul 10 1997 - 00:00:00 CDT