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

--- "Obnoxio The Clown" <obnoxio@hotmail.com> > wrote: >From: Chris Brauer <funky@funkytown.de> >> > from atable t, fred f >> >>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, I would have thought he'd name a temp table 'kaput'. >obviously. Well, in my case there was a guy called "t1" I really hated... I had a boss that always used fred for his temp tables and files because the folks that taught him used fred. I started using 'booger' just to be contrary. Other folks would look at him strangely when he'd say, "Clean up all your boogers, we're running out of space." when I'd have a few really large temp files on a smallish file system. == carlos Maintainer of the procrastinator's FAQ Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net