sql - TSQL 选择排序列与 Prev Current Next

Question

我有一个包含这些列的表格:

+-----------+--------------+-----------+
|PrevStation|CurrentStation|NextStation|
+-----------+--------------+-----------+
|-          |A             |B          |
+-----------+--------------+-----------+
|A          |B             |C          |
+-----------+--------------+-----------+
|B          |C             |D          |
+-----------+--------------+-----------+
|C          |D             |E          |
+-----------+--------------+-----------+
|D          |F             |-          |
+-----------+--------------+-----------+

现在我想通过以下方式表示一个 View :

+---------------+
|ClosestStations|
+---------------+
|A              |
+---------------+
|B              |
+---------------+
|C              |
+---------------+
|D              |
+---------------+
|E              |
+---------------+
|F              |
+---------------+

*注意:我想要排序的行与第一个表的约定*

您认为解决方案如何？

Answer 1

试试这个

Select [CLoseStation] from
(
   select PrevStation AS [CLoseStation],PrevStation ,NextStation,CurrentStation
   From T
   Union
   Select NextStation AS [CLoseStation],PrevStation ,NextStation,CurrentStation
   From T
   union
   Select CurrentStation AS [CLoseStation],PrevStation ,NextStation,CurrentStation
   From T
) AS S Order By PrevStation ,NextStation,CurrentStation ASC