Re: Maintaining minumum number of records
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 05 Apr 2002 16:08:49 GMT
Message-ID: <l_jr8.176874$af7.87021_at_rwcrnsc53>
Date: Fri, 05 Apr 2002 16:08:49 GMT
Message-ID: <l_jr8.176874$af7.87021_at_rwcrnsc53>
Which records do you want to keep?
If you don't care and there are 1,000,000 records and you want to keep 1,000
then
delete from mytable where rownum<999,000
That will delete all but 1,000 records - assume that the 1,000 records are
random.
Jim
"surya" <sai_surya_mp_at_yahoo.com> wrote in message
news:e4fde6e1.0204050630.2462aaf6_at_posting.google.com...
> Hi,
>
> I need to delete records, but i should maintain minimum number
> of records. Can you please suggest SQL query.
>
> Surya
Received on Fri Apr 05 2002 - 18:08:49 CEST