142 reputation
15
bio website
location
age
visits member for 2 years, 6 months
seen Apr 28 at 13:19

Dec
5
comment Removing duplicate entries for each hour
Thank you! It finally works :)
Dec
5
comment Removing duplicate entries for each hour
Now another problem is this: "table1.id" must appear in the GROUP BY clause or be used in an aggregate function
Dec
5
comment Removing duplicate entries for each hour
Already had that, but made it bold so it does not get overlooked ^^
Dec
5
comment Removing duplicate entries for each hour
There is just one problem: "function max(uuid) does not exist". I already tried something like this...
Nov
3
comment How do I remove duplicate entries in a given timeframe?
Thank you very much :D
Nov
3
comment How do I remove duplicate entries in a given timeframe?
This is almost what i need, I should have been more specific about the timeframe :) Now, what I want to do is doing this for every hour within a day or a longer timeframe.
Nov
3
comment How do I remove duplicate entries in a given timeframe?
No, as the only difference between them is the timestamp and the precision needs to be only up to full hours.
Nov
3
comment How do I remove duplicate entries in a given timeframe?
Yeah I have an id, which ist the primary key. Also it is possible that there exist entries with the same value of row2.