Re: (almost) duplicates

Thanks Hugo - I'm not sure if this will work for me as the time may expand
beyond a set periord of seconds (maybe to a few minutes?).  I get the gist
though - I appreciate your help and explaination!

Jeff

"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
 news:92nj411t3o257gh
 sm8jfm3oicddhrc6p3k@
4ax.com...
> On Mon, 28 Mar 2005 10:35:43 -0500, J. Clarke wrote:
> 
>
> Hi Jeff,
>
> Assuming Col1, Col2 and Col3 are exactly the same and Col4 is the
> datetime column with a few seconds difference, and that you want to
> delete the duplicates if the time difference is no more than 20 seconds,
> use:
>
> DELETE FROM MyTable
> WHERE EXISTS
> (SELECT    *
>  FROM      MyTable AS b
>  WHERE     b.Col1  = MyTable.Col1
>  AND       b.Col2  = MyTable.Col2
>  AND       b.Col3  = MyTable.Col3
>  AND       b.Col4  < MyTable.Col4
>  AND       b.Col4 >= DATEDIFF(second, 20, MyTable.Col4))
> (untested)
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)