sql - 如何让一列表变成两列？

Question

我想制作一个从一列到两列的表格。例如我有一个路径表。我有 4 行，我希望将它分成两列，就像在 PATH2 表中一样。我该怎么做？我希望这样做是为了计算每个路径值

╔══════╗
║ PATH ║
╠══════╣
║    1 ║
║    2 ║
║    3 ║
║    4 ║
╚══════╝

进入

╔══════╦═══════╗
║ PATH ║ PATH2 ║
╠══════╬═══════╣
║    1 ║     2 ║
║    2 ║     3 ║
║    3 ║     4 ║
╚══════╩═══════╝

Answer 1

SQL Fiddle

MS SQL Server 2008 架构设置:

create table YourTable
(
  PATH int
)

insert into YourTable values (1),(2),(3),(4)

查询 1:

select T1.PATH,
       Lead.PATH as PATH2
from YourTable as T1
  cross apply (
              select top(1) PATH
              from YourTable as T2
              where T2.PATH > T1.PATH
              order by T2.PATH
              ) as Lead

Results :

| PATH | PATH2 |
----------------
|    1 |     2 |
|    2 |     3 |
|    3 |     4 |