1)下一条记录
SELECT c.p
FROM
(
SELECT t.DUTY_ID, lead(t.DUTY_ID, 1, 0) over(order by t.DUTY_ID) as p
FROM OAM_DUTY_SCHEDULE t
) c
WHERE c.DUTY_ID = #{dutyId}
2)上一条记录:
select c.p
from (
select
t.DUTY_ID, lag(t.DUTY_ID, 1, 0) over(order by t.DUTY_ID) as p
from OAM_DUTY_SCHEDULE t
) c
where c.DUTY_ID = #{dutyId,jdbcType=VARCHAR}