All Questions

710
votes
55answers
687915 views

Remove duplicate values from JS array

I have a very simple JavaScript array that may or may not contain duplicates. names = new Array("Mike","Matt","Nancy","Adam","Jenny","Nancy","Carl"); I need to remove the duplicates and put the uni...
1097
votes
35answers
896766 views

How can I remove duplicate rows?

What is the best way to remove duplicate rows from a fairly large SQL Server table (i.e. 300,000+ rows)? The rows, of course, will not be perfect duplicates because of the existence of the RowID iden...
551
votes
33answers
425880 views

How do you remove duplicates from a list in whilst preserving order?

Is there a built-in that removes duplicates from list in Python, whilst preserving order? I know that I can use a set to remove duplicates, but that destroys the original order. I also know that I can...
274
votes
14answers
284521 views

Remove duplicate rows in MySQL

I have a table with the following fields: id (Unique) url (Unique) title company site_id Now, I need to remove rows having same title, company and site_id. One way to do it will be using the follo...
219
votes
16answers
167595 views

How to remove duplicate values from a multi-dimensional array in PHP

How can I remove duplicate values from a multi-dimensional array in PHP? Example array: Array ( [0] => Array ( [0] => abc [1] => def ) [1] => Array (...
508
votes
33answers
746187 views

Removing duplicates in lists

Pretty much I need to write a program to check if a list has any duplicates and if it does it removes them and returns a new list with the items that werent duplicated/removed. This is what I have but...
366
votes
33answers
548051 views

How do I remove repeated elements from ArrayList?

I have an ArrayList of Strings, and I want to remove repeated strings from it. How can I do this?
340
votes
2answers
352919 views

Delete all Duplicate Rows except for One in MySQL?

Possible Duplicate: Remove duplicate rows in MySQL How would I delete all duplicate data from a MySQL Table? For example, with the following data: SELECT * FROM names; +----+--------+...
129
votes
20answers
144217 views

Remove duplicates from an array of objects in JavaScript

I have an object that contains an array of objects. things = new Object(); things.thing = new Array(); things.thing.push({place:"here",name:"stuff"}); things.thing.push({place:"there",name:"morestu...
555
votes
20answers
627985 views

Find duplicate records in MySQL

I want to pull out duplicate records in a MySQL Database. This can be done with: SELECT address, count(id) as cnt FROM list GROUP BY address HAVING cnt > 1 Which results in: 100 MAIN ST 2 ...

Previous Next