3 ms·
Aha, I get it now. Yes, that's a little awkward. Although, 3 would re-appear when going back again but that might be even more confusing. But with OFFSET, you'
by lukaseder 13y ago
Aha, I get it now. Yes, that's a little awkward. Although, 3 would re-appear when going back again but that might be even more confusing.
But with OFFSET, you'd just have (frequently) shifting windows, right?
- JulianMorrison 13y agoI was trying to stream the table entries into a "tallying" type process. And of course it came out with the wrong numbers. Frustrating. I finally replaced the whole "chaser" process with a repeated full table scan with SQL aggregate functions. Wildly inefficient, but reliable.