Oracle中lag函数怎么用

SELECt lag(task_id,1,null) over(PARTITION BY ××× ORDER BY ×××),lead(task_id,1,null) over(PARTITION BY ×××ORDER BY ×××)FROM TABLE--之前回答过一个类似的帖子