3 ms·
I don't even know what that means but again, because it is SQLite, I up vote automatically ^_^
by usermac 8y ago
I don't even know what that means but again, because it is SQLite, I up vote automatically ^_^
- dougmwne 8y agoThere's a whole categories of analysis queries that are really easy to write with window functions and very annoying to write without. They help eliminate nested subqueries and self joins. This should make SQLlite a better choice for data analysis and reporting.