Re: What is the fastest way to delete duplicate rows from a table?

From: Chris Brauer <funky@funkytown.de> > > > select {keycols}, count(*) > > from atable > > group by {keycols} > > having count(*) > 1 > > into temp fred; > > > > delete from atable > > where rowid in ( > > select min(t.rowid) > > from atable t, fred f > > where {join conditions on {keycols} between t & f} > > group by {keycols} > > );> >That's funny, Art: every time you need a temp table (not worth to stay >after >use) >you call it "Fred". Does that mean you had a guy in your childhood named >Fred >you didn't like at all ? > >It would be funny to know every DBAs favourite "garbage-name"... :-) > >By the way: my garbage table sounds most of the time "jau" or "jepp" or >"jawoll"... German people are completely normal. It's the rest of us that are weird, obviously. Well, in my case there was a guy called "t1" I really hated... :0/ ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com