On 6 Apr 2018, at 8:58pm, R Smith <rsm...@rsweb.co.za> wrote: > my guess is Mr. Thomas inherited it from someone else who did not fully know > what they wanted to achieve, then googled a solution and found a hit on an > old stackoverflow question that was sort-of like what they wanted, but not > exactly.
[snip] > there is no amount of translation that would reproduce the sentiment. I think > the tutorial from Simon's post will shed light, but Dean, if you still have > trouble, could you perhaps show us your schema and explain what you want to > know That was my problem. I don't use SQL Server and I don't know what would make someone who did reach for PARTITION BY, and I don't like cursor functions in SQL. It seemed like they wanted GROUP BY but I wasn't sure. Therefore I was loth to post an exact query. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users