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