Timeline for Optimizing nested SQLite query
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 30, 2021 at 12:11 | comment | added | Charlieface | I've elaborated a little on how the calculation works | |
| Mar 30, 2021 at 12:11 | history | edited | Charlieface | CC BY-SA 4.0 |
added 299 characters in body
|
| Mar 30, 2021 at 12:04 | comment | added | duhaime |
This looks great! I've never used DENSE_RANK or PARTITION so will need to research them. But file_id is not nullable :)
|
|
| Mar 30, 2021 at 1:30 | history | edited | Charlieface | CC BY-SA 4.0 |
added 5 characters in body
|
| Mar 30, 2021 at 1:23 | history | answered | Charlieface | CC BY-SA 4.0 |