meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Feb 11 at 17:36 | |
| stats | profile views | 0 |
|
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. |
