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.


> 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.

sqlite-users mailing list

Reply via email to