Stack Overflow
Stack Overflow

Questions tagged [no-duplicates]

70 questions
0
votes
1 answer

MongoDB query to remove duplicate documents from a collection

I take data from a search box and then insert into MongoDB as a document using the regular insert query. The data is stored in a collection for the word "cancer" in the following format with unique "_id". { "_id": { "$oid":…
Vamshi
  • 97
  • 10
0
votes
1 answer

Joining four tables but excluding duplicates

I am trying to join four tables (users, user_payments, content_type and media_content) but I always get duplicates. Instead of seeing for example that user Smith purchased media_content_id_purchase 5011 for a price of 3.99 and he streamed…
clde
  • 219
  • 3
  • 12
0
votes
1 answer

VBA Copy ID's from one worksheet if no match is made

I do not have 10 reputation, so I'm unable to uploaded images, which would make this much, MUCH easier to explain... i posted a table example over to Mr. Excel forum here:…
CyrusTheVirus
  • 18
  • 7
0
votes
2 answers

find duplicates in a column, return the unique item and list its corresponding values from another column in python

I would like to remove duplicates from column 1 and return in colum 2 the related list of values associated to each unique item using python. The input is 1 2 Jack London 'Son of the Wolf' Jack London 'Chris Farrington' Jack London 'The God of His…
user3184877
  • 155
  • 2
  • 9
0
votes
2 answers

php Mysql avoid insert into duplicate entries

I have two tables names 'users' and 'bursary'. I want to copy all the username into 'bursary' table from 'users' table with condition the user Department=Bursary I want to avoid duplicate entries. my code is , $query25 = "INSERT INTO bursary…
satish
  • 41
  • 4
0
votes
2 answers

SAS: Proc sort nodupkeys error

I have two data sets : "mothers" - 5,512 observations where the variable "MOTHER" = 1 "all_women" - 2,336,750 observations where the variable "MOTHER" = 0 I combine the two as follows: data combined; set mothers all_women; Now as the mothers are…
user2568648
  • 3,001
  • 8
  • 35
  • 52
0
votes
1 answer

Where/ And Clause in Join Statement to avoid duplicates

Im new to SQL - I've looked through the posts but couldn't quite work out the answer to my question sorry. I'm trying to do what I think should be a simple query, using a where/ or statement in my join clause. The problem is I seem to be getting…
CathyBB
  • 1
0
votes
1 answer

c# ConfigurationSection not returning duplicate names

I have a configuration section reading from a config file. The xml looks like this …
jAC
  • 3,155
  • 3
  • 18
  • 29
0
votes
2 answers

TSQL Insert into table from 2 tables without duplicates based on 2 columns with datetime cast

This is a real life example, please take a look at my sqlfiddle, http://sqlfiddle.com/#!3/d8902/1 I have 3 tables, TickData where all data should go to and 2 source tables with data that have some overlapping data, [ES 09-11_Part01] and [ES…
DeveloperDavid
  • 157
  • 2
  • 7
  • 16
0
votes
2 answers

how to check a row for duplicate ones?

I have a openoffice calculator where I have some transactions... there are 3 columns that I need to compare as one... they can be repeated individually or in peer but never those 3 at the same time by other row... so I need some idea so I can check…
user3198655
  • 9
  • 2
0
votes
5 answers

Java reading and writing to same file

I'm using the following code to search specific files in my computer and write the absolute path in a text file. My problem is that every time I run this code it add duplicate lines into text file, i want to add only those lines(file path) which are…
user3090016
  • 3
  • 1
  • 2
0
votes
1 answer

Avoid Duplicates in an array queue / move to back

I have a homework assignment, this is my first question on here and have been working at this for a while. Normally I can figure things out but i'm really stuck. Here is my code and my output using a tester. My moveToBack is kind of a copy paste…
user2950360
  • 1
  • 1
0
votes
4 answers

noDups()method to remove all duplicates from the array

It removes the duplicates in the Array but skips one item near the end. Can anybody help me fix this? The output would be like this: 77 44 55 33 55 22 88 11 33 66 33 Removing duplicates... 77 44 55 22 88 11 33 It skipped the '66' when it…
lmpgdn
  • 19
  • 1
  • 1
  • 7
0
votes
2 answers

mySQL joined tables no duplicates

I have two tables: One table contains poetry submitted by members. The other is the member's table. Both tables contain The Member's ID (MID and SubMID). I want to display the last 15 poems that have been updated. However, I want to display ONLY…
user2827532
  • 3
  • 2
0
votes
1 answer

Duplicates in a LEFT JOIN

I am using LEFT JOIN to join two tables but it is returning a few duplicates. This is my query: SELECT tblDrill.Hole_ID, tblAssay.MidPoint, tblAssay.SampleNumber, tblAssay.Gold, tblMagSus.MagSus FROM tblDrill LEFT JOIN tblMagSus ON…
LIVIKA
  • 1
1 2 3
4
5