🚀 go-pugleaf

Louis,

Yea, that's the whole idea--to not delete all the rows that are
duplicated, just the subsequent rows.

Let me know!
-- 
 Les Gainous, lesgainous@earthlink.net

 Visit my web page at
      http://home.earthlink.net/~lesgainous

 Looking for a Client-Server job in California?
      http://home.earthlink.net/~lesgainous/jobs.html


Louis Davidson wrote:
> 
> Try     select          col1,
>                         count(*)
>         into            #hold
>         from            myTable
>         group by        col1
>         having          count(*) > 1
> 
> delete  myTable
> from    myTable, #hold
> where   myTable.col1 = #hold.col1
> 
> The only problem is that this will delete both rows. There are better
> solutions that will not, if you want I could go through them.
> 
> --
> ----------------------------------------------------------------------------
> ------------
> Louis Davidson
> Christian Broadcasting Network
> 
> work: louis.davidson@cbn.org
> home: vallou@infi.net
> virtual address: http://members.aol.com/vallou
> 
> "I used to think anyone doing anything weird was weird.
> I suddenly realized that anyone doing anything weird wasn't
> weird at all and that it was the people saying they were weird
> that were weird."
> Paul McCartney
> ----------------------------------------------------------------------------
> ------------
> 
> Les Gainous <lesgainous@earthlink.net> wrote in article
> <3276F4A7.1842@earthlink.net>...
> > I'm using MS-SQL Server 6.5 (but any generic SQL syntax would be
> > appreciated):
> >
> > How can I delete multiple occurrences of a row within a table. I know
> > how to display the rows which are duplicated:
> >
> >       select          col1,
> >                       count(*)
> >       from            myTable
> >       group by        col1
> >       having          count(*) > 1
> >
> > But now that I have that listing, how can I delete the second (or third,
> > or...) occurrence of the row--preserving the first occurrence.
> >
> > Thanks in advance!
> > Les
> >