Stack Overflow
Stack Overflow

Questions tagged [no-duplicates]

70 questions
44
votes
5 answers

How to Use Multiple Columns in Partition By And Ensure No Duplicate Row is Returned

I have used multiple columns in Partition By statement in SQL but duplicate rows are returned back. I only want distinct rows being returned back. This is what I have coded in Partition By: SELECT DATE, STATUS, TITLE, ROW_NUMBER() OVER (PARTITION BY…
Felicia Soh
  • 815
  • 3
  • 18
  • 32
12
votes
2 answers

R rbind error row.names duplicates not allowed

There are other issues here addressing the same question, but I don't realize how to solve my problem based on it. So, I have 5 data frames that I want to merge rows in one unique data frame using rbind, but it returns the error: "Error in…
Jecogeo
  • 339
  • 1
  • 4
  • 10
8
votes
5 answers

Does Javascript supports Sets?

Does Javascript supports Sets(list with unique objects only) ? I have found this link, but from what I remember foreach in JS in not supported by every browser.
IAdapter
  • 62,595
  • 73
  • 179
  • 242
7
votes
5 answers

Prevent duplicate entries in arraylist

Say I create some object class like so public class thing { private String name; private Integer num; public oDetails (String a, Integer b) { name = a; num = b; } ...gets/ sets/ etc Now I…
tyh
  • 977
  • 1
  • 8
  • 22
6
votes
2 answers

In SQL, how can I delete duplicate rows based on multiple columns?

I know I can run the following query below to find "duplicate" rows based on multiple columns doing something like this: SELECT PosId, OrgId FROM PosOrg GROUP BY PosId, OrgId HAVING COUNT(*) > 1 but now I want to delete the duplicate…
leora
  • 188,729
  • 360
  • 878
  • 1,366
5
votes
4 answers

Removing Identical Objects in Ruby?

I am writing a Ruby app at the moment which is going to search twitter for various things. One of the problems I am going to face is shared results between searches in close proximity to each other time-wise. The results are returned in an array of…
Patrick O'Doherty
  • 1,642
  • 2
  • 14
  • 20
5
votes
5 answers

Random string with no duplicates

I'm trying to generate a 16 chars random string with NO DUPLICATE CHARS. I thoght that it shouldn't be to hard but I'm stuck. I'm using 2 methods, one to generate key and another to remove duplicate chars. In main I've created a while loop to make…
Ladislav Biskupec
  • 93
  • 2
  • 12
4
votes
1 answer

Find all strings in a file that are the same and print the value after in perl

Good Day guys. I am trying to print from an excel file to a ini file, I have the excel and ini writing sorted, but my issue lies with getting the values without duplicating. The excel file will contain something like this House | …
Harry Barry
  • 194
  • 7
3
votes
7 answers

How do I add non-existing values in from arrayList2 to arrayList1?

Let's say I have an arrayList1 of Points. The data structure is like this : (1,2)->(2,2)->(3,2)->(4,2)->(5,2) I have another arrayList2 of Points : (2,2)->(1,2)->(8,5)->(9,3) How do I compare the two lists and add non-existing values from arrayList2…
John Evans Solachuk
  • 1,953
  • 5
  • 31
  • 67
3
votes
1 answer

Python mysql check for duplicate before insert

here is the table CREATE TABLE IF NOT EXISTS kompas_url ( id BIGINT(20) NOT NULL AUTO_INCREMENT, url VARCHAR(1000), created_date datetime, modified_date datetime, PRIMARY KEY(id) ) I am trying to do INSERT to kompas_url table…
Michelle Jun Lee
  • 227
  • 2
  • 7
  • 14
3
votes
4 answers

jQuery selector to get just the first occurrence of every value

I have an HTML like this:
I would like to use jQuery to…
pumpkinzzz
  • 2,907
  • 2
  • 18
  • 32
3
votes
2 answers

Can I make Rails update_attributes with nested form find existing records and add to collections instead of creating new ones?

Scenario: I have a has_many association (Post has many Authors), and I have a nested Post form to accept attributes for Authors. What I found is that when I call post.update_attributes(params[:post]) where params[:post] is a hash with post and all…
yuklai
  • 1,595
  • 1
  • 14
  • 26
2
votes
1 answer

SQLite: remove duplicate rows when entire row is not unique

I'm creating an SQLite view to track customer emails and their accounts. There are some customers who created multiple accounts with the same email address. Using SQLite, is there a way to restrict the view to return each email only once…
Mike McMillan
  • 21
  • 2
2
votes
1 answer

php array stack ordering

I am trying to sort this array in php: Array ( [Levi Self] => Array ( [0] => Portraits [1] => Abstract ) [Portraits] => Array ( [0] => Megan ) [Abstract] => Array …
Levi Self
  • 333
  • 1
  • 3
  • 5
2
votes
5 answers

Removing duplicates from a linked-list in Java without the use of extra buffer

I am reviewing some snippets of code for an upcoming test. I saw this in my notes, and just now realized that this code for method 1 doesn't actually remove duplicates if the list is in this way A -> B -> C -> A. I wrote an alternative function…
Lucia Rogers
  • 21
  • 1
  • 1
  • 2
1
2 3 4 5