Re: SQL query "delete all but one"?

From: Paul Quenneville <paulq_at_home.com>
Date: Wed, 17 Oct 2001 20:09:57 GMT
Message-ID: <pAlz7.66002$5h5.28885438@news3.rdc2.on.home.com>

delete from tablename
where number=1234
and rowid != (select min(rowid) from tablename

                         where number=1234)

"Andreas Homrighausen" <andreas.homrighausen_at_fernuni-hagen.de> wrote in message news:3BCDD89F.4E574AAA_at_fernuni-hagen.de...
> 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 - 15:09:57 CDT