Article View: comp.databases.ms-sqlserver
Article #31Re: - Delete Multiple Rows?
From: Chris Godschall
Date: Fri, 01 Nov 1996 00:00
Date: Fri, 01 Nov 1996 00:00
24 lines
1575 bytes
1575 bytes
Check out the Technet Article Q139444 "INF: How to Remove Duplicate Rows From a Table". I seem to remember it had a couple different ways to do what you want to do. good luck chris >> > 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 >> >
Technical Details
Message-ID:
<327a573d.3670857@newsreader.digex.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3276F4A7.1842@earthlink.net> <01bbc734$69c95690$79431a9f@louman-s-home> <3278D229.5729@earthlink.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f4bf8,e42b60ff2edc4f24 X-Google-Attributes: gidf4bf8,public X-Google-Thread: 104de1,e42b60ff2edc4f24 X-Google-Attributes: gid104de1,public X-Google-Thread: 11301e,e42b60ff2edc4f24 X-Google-Attributes: gid11301e,public X-Google-Thread: f6611,e42b60ff2edc4f24 X-Google-Attributes: gidf6611,public From: cgodscha@lightind.com (Chris Godschall) Subject: Re: - Delete Multiple Rows? Date: 1996/11/01 Message-ID: <327a573d.3670857@newsreader.digex.net> X-Deja-AN: 193750156 references: <3276F4A7.1842@earthlink.net> <01bbc734$69c95690$79431a9f@louman-s-home> <3278D229.5729@earthlink.net> content-type: text/plain; charset=us-ascii organization: DIGEX mime-version: 1.0 newsgroups: comp.databases.ms-sqlserver,comp.databases.theory,bit.databases.mssql-l,microsoft.public.sqlserver.programming