如何将行转换为列 [英] How do convert rows into columns

问题描述

我有emp表如下



Empid Empname月工资



1 A 1 3000

2 B 2 5000

3 C 3 8000

4 D 4 9000

5 E 5 7000





从以上我想要的输出如下





Empid Empname 1 2 3 4 5



1 A 3000 5000 8000 9000 7000





获得以上输出如何在sql server中编写查询



我尝试过： < br $>


i有emp表如下



Empid Empname月工资



1 A 1 3000

2 B 2 5000

3 C 3 8000

4 D 4 9000

5 E 5 7000





从上面我想要的输出如下





Empid Empname 1 2 3 4 5



1 A 3000 5000 8000 9000 7000





从获得以上输出如何在sql server中编写查询

i have emp table as follows

Empid Empname Month Salary

1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000


from the above i want the output as follows


Empid Empname 1 2 3 4 5

1 A 3000 5000 8000 9000 7000


from getting a above output how to write the query in sql server

What I have tried:

i have emp table as follows

Empid Empname Month Salary

1 A 1 3000
2 B 2 5000
3 C 3 8000
4 D 4 9000
5 E 5 7000


from the above i want the output as follows


Empid Empname 1 2 3 4 5

1 A 3000 5000 8000 9000 7000


from getting a above output how to write the query in sql server

推荐答案

您使用PIVOT查询：使用PIVOT和UNPIVOT [ ^ ]

You use a PIVOT query: Using PIVOT and UNPIVOT[^]

这篇关于如何将行转换为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！