Top "Duplicates" questions

How do I find duplicates across multiple columns?

So I want to do something like this sql code below: select s.id, s.name,s.city from stuff …

sql sql-server sql-server-2008 duplicates

How to find all duplicate from a List<string>?

I have a List<string> which has some words duplicated. I need to find all words which are …

c# list duplicates

Java Scanner class reading strings

I got the following code: int nnames; String names[]; System.out.print("How many names are you going to save: "); …

java string duplicates java.util.scanner

In Javascript, how do I check if an array has duplicate values?

Possible Duplicate: Easiest way to find duplicate values in a javascript array How do I check if an array has …

javascript duplicates

How to merge 2 List<T> and removing duplicate values from it in C#

I have two lists List that I need to combine in third list and remove duplicate values from that lists …

c# list merge duplicates

MySQL duplicate entry error even though there is no duplicate entry

I am using MySQL 5.1.56, MyISAM. My table looks like this: CREATE TABLE IF NOT EXISTS `my_table` ( `number` int(11) NOT …

mysql primary-key mysql-error-1062 duplicates

Python copy files to a new directory and rename if file name already exists

I've already read this thread but when I implement it into my code it only works for a few iterations. …

python copy duplicates directory

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1922-1' for key 'IDX_STOCK_PRODUCT'

While creating product, at the last step after retrieving for a time, Magento gives following error-: SQLSTATE[23000]: Integrity constraint violation: 1062 …

magento constraints mysql-error-1062 duplicates

MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query

I have a SQL query where I want to insert multiple rows in single query. so I used something like: $…

sql mysql duplicates

How do I delete all the duplicate records in a MySQL table without temp tables

I've seen a number of variations on this but nothing quite matches what I'm trying to accomplish. I have a …

mysql sql duplicates sql-delete unique-index