select 'L:' border, empno from emp where empno+1 not in (select empno from emp) and empno <> (select max(empno) from emp)
union
select 'R:' border, empno from emp where empno-1 not in (select empno from emp) and empno <> (select min(empno) from emp)
order by empno, border desc;
union
select 'R:' border, empno from emp where empno-1 not in (select empno from emp) and empno <> (select min(empno) from emp)
order by empno, border desc;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/85159/viewspace-464480/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
