把案例的sql改改就能用了，textEditor0这个是数据的条目数，我这其实是固定的，a就是案例里的
select sort,value,rn from (
select *,row_number() over(order by sort) rn from pl where year=2023 and month=2) a
where rn between ${5*(mod((datetonumber(now())-datetonumber(a))/1000,round((textEditor0/5),0)))} and ${5*(mod((datetonumber(now())-datetonumber(a))/3000,round((textEditor0/5),0))+1)}
1min目标场景问卷
立即参与
