DM7不支持分析函数？

〇〇

lead lag支持吗？

myth8860

支持：

with a as (select 1 id,'a' name from dual
  union
  select 2 id,'b' name from dual
  union
  select 3 id,'c' name from dual
  union
  select 4 id,'d' name from dual
  union
  select 5 id,'e' name from dual
  )
  select id,name,lag(id,1,'')over(order by name) from a;