我有特殊的sql查询,如:
with b as (select t.* --,row_number() over (order by next_number asc)as "rn"
from(
select *
from (
select a.*,lead(a.localnumber,10) OVER (
ORDER BY a.objectid) next_number
from
a
)q where q.next_number-q.localnumber=10 limit 1-- offset '||record_count*(val_offset)||'
)t )
select a.* from a,b
where a.localnumber>=b.localnumber and a.prefix=b.prefix and a.localnumber<b.next_number order by a.identifier
结果我只需要一个*,这意味着它适合模型a。 我还想应用一些过滤器,我可以将原始sql结果放入模型A并应用一些列过滤器吗
目前没有回答
相关问题 更多 >
编程相关推荐