sql server 2012以后的版本增加的函数LEAD
with tmp as (select 1 as id,66 as number_s
union all
select 2 as id,99 as number_s
union all
select 3 as id,77 as number_s
union all
select 4 as id,63 as number_s
)
select
id,
number_s,
LEAD(number_s) OVER (ORDER BY id) AS OneArgs
from tmp