On 15 Feb 2017, at 11:58am, Petite Abeille <petite.abei...@gmail.com> wrote:
> On Feb 15, 2017, at 11:16 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > >> SQLite does not have windowing functions. > > A continuous/continual tragedy indeed :| Windowing breaks the philosophy behind SQL. Rows are meant to be members of a set, and your operations on them are meant to be set operations. There is no implicit order for set elements. That’s why bare-bones SQL implementations don’t have cursors or windowing. > Still, worthwhile mentioning The Tabibitosan Method, for reference purpose: > > http://www.orchestrapit.co.uk/?p=53 > https://community.oracle.com/message/3991678 > > Rather nifty in its simplicity and power. Sadly, out of reach to SQLite > dwellers. Actually SQLite can do it, by iterating using recursive common table expressions: <https://www.sqlite.org/lang_with.html> . It looks like an interesting programming exercise, though there’s a danger it will lead to unreadable code (a perpetual danger with WITH). You would need a spare column in the table to store the 'group' values in. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users