No announcements
Found 2826725 threads
-
4 Voteshow to delete duplicate rows in access
No way to delete selectively only one of the duplicate rows.Answered | 7 Replies | 8718 Views | Created by E_gold - Thursday, June 21, 2012 10:41 AM | Last reply by Miguel Arroyo Pérez - Friday, June 22, 2012 6:17 PM
-
0 Votes
delete duplicate rows
1 -JensJens K.Answered | 3 Replies | 3607 Views | Created by KUMAR_1234 - Tuesday, May 26, 2009 11:14 AM | Last reply by masher2 - Tuesday, May 26, 2009 11:50 AM -
3 Votes
deleting duplicate rows
Following article deals with the same topic: http://www.sqlusa.com/bestpractices/deleteduplicates/ Kalman Toth, SQL Server & BI ...Answered | 5 Replies | 5396 Views | Created by anki2010 - Saturday, June 4, 2011 1:44 AM | Last reply by anki2010 - Sunday, June 5, 2011 1:39 AM -
0 Votes
Finding and deleting duplicate row in
How can I find the (1) duplicate value and delete it?Answered | 7 Replies | 897 Views | Created by Albo44 - Tuesday, September 6, 2016 8:47 PM | Last reply by Michiel Rozema - NL - Wednesday, September 7, 2016 8:02 AM -
3 Votes
Deleting duplicate rows
[Staff] ) delete from [dbo].Answered | 6 Replies | 671 Views | Created by Y a h y a - Friday, March 31, 2017 1:50 AM | Last reply by SQLNeophyte - Monday, April 3, 2017 4:59 AM -
0 Votes
How to delete duplicate rows based on the key?
If its a table you could write a query to remove those records in ur source query.Answered | 8 Replies | 3901 Views | Created by alexuwang - Thursday, March 11, 2010 11:24 PM | Last reply by Todd McDermid - Monday, March 15, 2010 6:05 PM -
1 Votes
Delete duplicate rows from table
Hi ganeshsg, To delete the duplicated rows in your case, the below demonstration would work.Answered | 7 Replies | 1163 Views | Created by ganeshsg - Tuesday, July 21, 2015 1:48 PM | Last reply by Eric__Zhang - Wednesday, July 22, 2015 6:07 AM -
1 Votes
MS Access - Deleting duplicated rows
Presumably some combination of columns should be unique- that's how you are identifying duplicates.Answered | 4 Replies | 685 Views | Created by H Souza - Thursday, December 17, 2015 3:31 AM | Last reply by Paul23 - Saturday, December 19, 2015 2:05 PM -
6 Votes
How to remove duplicate rows
1 PS.Shakeer Hussain HyderabadAnswered | 8 Replies | 4592 Views | Created by Sam233 - Monday, March 1, 2010 2:25 PM | Last reply by Syed Shakeer Hussain - Monday, March 1, 2010 3:50 PM -
0 Votes
how to delete duplicate in all rows ?
====================Blogs: www.sqlserver2005forum.blogspot.com ============== Here you are deleting one row at a time, so think about performance if you ...Answered | 7 Replies | 3276 Views | Created by srajmuneer - Thursday, April 12, 2012 2:23 PM | Last reply by srajmuneer - Saturday, April 14, 2012 7:29 PM -
0 Votes
How to delete Duplicates
Kalman Toth SQL SERVER 2012 & BI TRAINING New Book: Beginner SQL Programming Using Microsoft SQL ...Answered | 9 Replies | 1896 Views | Created by miruan - Monday, October 22, 2012 8:03 AM | Last reply by Kalman Toth - Sunday, October 28, 2012 11:54 PM -
0 Votes
deleting the duplicate rows
https://support.microsoft.com/en-us/help/139444/how-to-remove-duplicate-rows-from-a-table-in-sql-server or ask them ...Answered | 1 Replies | 1048 Views | Created by Manoj Gokhale - Thursday, July 6, 2017 3:10 PM | Last reply by Dave Patrick - Thursday, July 6, 2017 3:21 PM -
1 Votes
how to delete duplicate rows from table
1 SELECT * FROM @T Best Regards, Melissa Suciadi If you have found this post helpful, please click the 'Vote as Helpful ' ...Answered | 1 Replies | 5574 Views | Created by rautchetan - Monday, November 9, 2009 9:32 AM | Last reply by Melissa Suciadi - Monday, November 9, 2009 9:34 AM -
3 Votes
how to delete duplicate records in sql server?
If all the rows are identical then you can also use SET ROWCOUNT to limit the deletion of the identical records.Answered | 4 Replies | 2473 Views | Created by programmer on .net - Friday, January 25, 2013 7:36 AM | Last reply by MasaSam - Friday, January 25, 2013 12:29 PM -
1 Votes
how to delete duplicates on condition in power query
https://support.office.com/en-us/article/Remove-duplicates-Power-Query-d9cffc69-dc5d-4d94-8b66-72779688874dPlease click Mark As Answer if my post helped.Answered | 2 Replies | 4984 Views | Created by AlexMartini - Tuesday, October 25, 2016 1:35 AM | Last reply by Angelia Zhang - Tuesday, October 25, 2016 10:28 AM -
0 Votes
how delete duplicate records in access table by Query
Hi sayed, Base on the unique record IDs is the good way to delete the duplicate rows, I don’t find other better way to accomplish it.Answered | 4 Replies | 512 Views | Created by sayed gamal - Tuesday, May 12, 2015 1:31 PM | Last reply by Starian chen - Thursday, May 14, 2015 6:43 AM -
4 Votes
Need to remove duplicate rows in sql server.
here is a small article that describes with example how you can achieve this ...Answered | 7 Replies | 12319 Views | Created by Amit_kala - Sunday, May 20, 2012 10:22 AM | Last reply by Amit_kala - Wednesday, March 20, 2013 3:17 PM -
0 Votes
SQL delete excess duplicates
1; --sql 2000 delete from #t where id not in( select MIN(id) from #t group by Name, LName ) Best Regards, Melissa ...Answered | 2 Replies | 5078 Views | Created by Rabbitholes - Wednesday, November 18, 2009 11:11 PM | Last reply by Melissa Suciadi - Thursday, November 19, 2009 1:38 PM -
1 Votes
Delete duplicate id ROW using SQL Management Studio
How to remove duplicate rows from a table in SQL ...Answered | 4 Replies | 12884 Views | Created by joe_ace - Wednesday, June 17, 2009 1:11 PM | Last reply by Praveen Barath - Thursday, June 18, 2009 11:54 AM -
6 Votes
How to write a query to remove duplicate rows?
You have several way for Select duplicate rows.Answered | 9 Replies | 1015 Views | Created by salvationishere - Monday, December 7, 2015 9:47 PM | Last reply by AbsolutelyFreeWeb - Tuesday, December 8, 2015 8:29 PM - Items 1 to 20 of 2826725 Next ›
No announcements
