Kind of annoying that when the author shows a screenshot of the sample data he's using for his queries that he doesn't include 2 of the fields that are in the queries. Makes it harder to "play along at home"
For their ntile example (on page2) I don't think I've seen a window function used with a "group by". Does the ntile un-group the groups? Something just looks wrong there between the query and the results shown below it. But like you I don't know enough to say if that's right or if it's on crack. -----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of Simon Slavin Sent: Wednesday, September 04, 2019 12:15 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] Window functions I ran into this two-part article, probably on Hacker News: <http://www.helenanderson.co.nz/sql-window-functions-part-1/> I tried comparing it with <https://www.sqlite.org/windowfunctions.html> but I don't know enough to be able to tell whether the language used in the article is compatible with the way window functions are implemented in SQLite. Could someone who knows more than I do take a look and post a summary ? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users