Stack Overflow
Stack Overflow

Questions tagged [ignore-duplicates]

13 questions
5
votes
4 answers

Remove duplicates column combinations from a dataframe in R

I want to remove duplicate combinations of sessionid, qf and qn from the following data sessionid qf qn city 1 9cf571c8faa67cad2aa9ff41f3a26e38 cat biddix fresno 2 …
megv
  • 1,421
  • 5
  • 24
  • 36
5
votes
1 answer

SQL deduplicate from two columns

I've been struggling with this for quite some time but i just can't figure it out. I have a table with 3 columns. 2 columns containing names and the third one containing the Damerau Levensthein distance (…
lightxx
  • 1,037
  • 2
  • 11
  • 29
3
votes
1 answer

Ignore Duplicate Values on Index prevents FOREIGN KEY constraint

Due to some architectural reasons I have to ignore duplicate values on the index. It works perfectly well - except, when I am inserting wrong data. I am trying to insert value to the FK column that is supposed to throw: The INSERT statement…
Falcon
  • 650
  • 1
  • 8
  • 24
2
votes
3 answers

SQL: Detect duplicate customers

im trying to create a sql query, that will detect (possible) duplicate customers in my database: I have two tables: Customer with the columns: cid, firstname, lastname, zip. Note that cid is the unique customer id and primary key for this…
sockeqwe
  • 15,574
  • 24
  • 88
  • 144
2
votes
1 answer

MS SQL Server - how to ignore/ discard very rare duplicate rows during table insert

I recently discovered an error in a client API. It sends pages of unique records based on timestamps. Every so often, it will send the same exact record on end of the previous page, and start of the next page. I was operating under the assumption…
user45867
  • 887
  • 2
  • 17
  • 30
1
vote
1 answer

HTML5 LocalStorage - check for duplicate values

I'm saving a list of images (from a gallery) to a device using LocalStorage. I've solved the problem for the most part - getting data in and out, and populating an HTML list of items that are in there. Easy. I'm now trying to put a check in to look…
adnrw
  • 1,038
  • 6
  • 13
1
vote
0 answers

Excel COUNTIF / RANKIF while ignoring duplicates

I'm working on a football database of weekly scores. Each row represents an individual's weekly performance (e.g. catches, yards, TDs), while also containing their weekly fantasy score, and their season total fantasy score. Each record now needs a…
Dave M
  • 51
  • 8
1
vote
0 answers

How to ignore insert if already exists using SQL Server?

I have one insert statement that inserts multiple rows at once using VALUES and each set of values separated by a comma like this: INSERT INTO link_instance_message (instance_id, message_id) VALUES ( (select instance_id from instance where…
Brian T Hannan
  • 3,925
  • 18
  • 56
  • 96
1
vote
1 answer

SQL Arithmetic Overflow for Identity Insert

I have an error with arithmetic overflow inserting values into a lookup table with a row-id set as TINYINT datatype. This IS NOT a case where the number of unique records exceeds 255 values. This is a bit more unusual and did not occur during the…
user1884677
  • 9
  • 3
1
vote
3 answers

MySQL Select if field is unique or null

Sorry, I can't find an example anywhere, mainly because I can't think of any other way to explain it that doesn't include DISTINCT or UNIQUE (which I've found to be misleading terms in SQL). I need to select unique values AND null values from one…
BenR
  • 13
  • 3
0
votes
1 answer

filter continuous duplicate chars in a string

Is there any problems in my code ,or to be improved ? #include #include char * filterdupchar(char* s,int n){ char *tmp2 = s ; char *tmp =(char*)malloc(n*sizeof(char)); for(int j=0;j
Roger
  • 85
  • 1
  • 9
0
votes
1 answer

Drools Fusion De-duplication

I defined a class which acts as event to the rule engine It has the following members 1. phone number 2. latitude 3. longitude How do I formulate a rule wherein 1. The rule counts the number of distinct people in the same location 2. Same person if…
subbu
  • 65
  • 6
0
votes
1 answer

Returning duplicated values only once from a join query

I'm trying to extract info from a table in my database based on a persons job. In one table i have all the clients info, in another table linked by ID_no their job title and the branches theyre associated with. the problem I'm having is when i join…
germantom
  • 405
  • 2
  • 6
  • 15