python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
MYSQL - not distinct but eliminate
From a SELECT I get this result:
u.id, c.id
101, 33
104, 57
105, 51
A UNION SELECT DISTINCT finds following records:
u.id, c.id
104, 57
The final result is:
u.id, c.id
101, 33
104, 57
105, 51
But I wa...
Jørn Vase
Votes: 0
Answers: 0
Pymongo error while trying to call distinct on a collection
I'm getting this weird error. I am following the documentation closely and don't understand what I am doing wrong. I pasted an minimal example to replicate the error. Any tip to this fix?
Error messag...
John Doe
Votes: 0
Answers: 1
SQL: Insert Into Table 1 From Table 2 then Update Table 2 - Performance Increase
I am working to increase the speed and performance for a database process that I have inherited. The basic steps, prior to this process, is a utility uploads about a million or more records into an U...
Chris Donnelly
Votes: 0
Answers: 1
PostgreSQL SELECT result with a distinct ids that prefers specific values from another table
I have a some_dictionary table and a some_dictionary_language table with data in multiple languages(and a reference to some_dictionary).
I need to get unique values on some_dictionary.id preferring th...
bezdroznik
Votes: 0
Answers: 1