Forum Discussion
What do you think of thunks?
OK, so the most likely response by far is going to be "I don't". However, I tried one of Omid Motamedisedeh's regular challenges and found it a suitable problem for exploring some of the lesser k...
sql:
create temp table aa as
SELECT rowid old_rowid,*, max(`Value`) OVER (
ORDER BY rowid ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING
) AS group_max FROM RollingMax;
select * from aa;
//list max value of each range BETWEEN 2 PRECEDING AND 2 FOLLOWING
select Date,Value from aa where group_max=Value order by old_rowid;
//filter Value equal group_max
I have seen your posts on the use of sql for calculations far from the simple extraction, filtering and joining of text from tables that I associate with scope for sql. What is not obvious to me is where the scripts are loaded, in particular within which app?
Online App and command line shell.
Thank you. That was something I hadn't come across.