Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: query help wanted
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 Tue Jul 08 1997 - 00:00:00 CDT