Timeline for How can I remove identical (but negative) rows that are also in some days of each other from a SELECT on a table
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 9, 2020 at 14:28 | comment | added | Scott |
@bbaird by overlapping I mean in a table sorted by date one pair may exist within another pair, or one pair may include one member of another pair. I wasn't sure if this would influence the query. Basically assume nothing about the dates or values. I'm running MySQL 5.6. Thanks for mentioning "key". I checked my table - duh - I was indexing neither column. Added indexes for both columns and now the query runs in a few seconds. Cheers.
|
|
| Sep 9, 2020 at 13:02 | comment | added | user212533 | Which version of MySQL and what engine are you using? Could you provide more detail, I'm a little confused by "Pairs of differing values may overlap 7 day periods"? Also provide the relevant key information for the table. | |
| Sep 9, 2020 at 6:32 | answer | added | Akina | timeline score: 0 | |
| Sep 9, 2020 at 5:57 | history | asked | Scott | CC BY-SA 4.0 |