我该如何横向显示表格数据?
这是我的表格定义:
create table [User]
(
Id int primary key identity(1,1),
Name varchar(50),
Gender varchar(10)
)
以下是我在 SQL Server 表中拥有的数据。
+====+=======+========+
| Id | Name | Gender |
+====+=======+========+
| 1 | Fahad | Male |
+----+-------+--------+
| 2 | Saad | Male |
+----+-------+--------+
| 3 | Asif | Male |
+====+=======+========+
我希望将其水平展示如下:
+========+=======+======+======+
| Id | 1 | 2 | 3 |
+========+=======+======+======+
| Name | Fahad | Saad | Asif |
+--------+-------+------+------+
| Gender | Male | Male | Male |
+========+=======+======+======+