4 ms·
Sometimes I'd rather do python magic than self join correlated sub-queries or write window functions and have it all become a convoluted mess. But I see your po
by gigatexal 10y ago
Sometimes I'd rather do python magic than self join correlated sub-queries or write window functions and have it all become a convoluted mess. But I see your point.
edit: i'm still trying to train myself to think in a relational way.
- zie 9y agorelations are awesome, but it def. takes training! I'd suggest avoiding window functions for pagination.. see http://use-the-index-luke.com/no-offset http://use-the-index-luke.com/no-offset as one method.