Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL query "delete all but one"?
In a table "tablename" with a column "number" I want to
delete all but one rows with number=1234.
Does Oracle offer something like
delete all but one from tablename where numer=1234; ?
Thanks!
Andreas Received on Wed Oct 17 2001 - 14:14:39 CDT