Re: trouble with an SQL statement

"FairPlay" <not_at_here.com> wrote in message news:4255c5bb$0$289$cc9e4d1f_at_news-text.dial.pipex.com...
>
> "Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
> news:1112912995.145557.9860_at_l41g2000cwc.googlegroups.com...
> > If you can easily identify the rows you want to keep and you have
> > exclusive access to the table then why not use a Create Table As Select
> > of the rows you want, truncate the original table, and then reinsert
> > the CTAS'd rows back.
> >
> > The above method would probably be much faster than say deleting where
> > the rowid in not in a group by subselect where you select the
> > min(timestamp) row grouped by the key columns and description.
> >
>
> Thanks mark. I "think" I got it working with a "minus". The the
performance
> is poor I'll look at your suggestion.

*If* the performance is poor :) Received on Thu Apr 07 2005 - 19:15:00 CDT