blob: 1d954c20e7e99bc94fc31e65fb17e9735162d377 [file] [log] [blame]
select
lag(line_no) over(partition by position_id order by sub, employee_id) as `lag`
from dfs.`window/b4.p4`