一、问题描述
存储一个环结点的表,输出相邻环结点记录。
环结点表如下:
预期结果:1->3,3->4,4->1.
二、解决方案
declare @minVertex int
Select @minVertex= min(Vertex) from CircleVertex
select vertex as parentVertex,
isnull((select top 1 vertex from circleVertex R
where R.id > T.id
order by R.id
),@minVertex) as childVertex