OVER(PARTITION BY)函數用法 - 藍紫 - 博客園
lead(expresstion,,) 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, lead(id,1,'')over(order by ....