2014-03-17 23:33
最佳答案
其他回答
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
DECLARE
@TestTable
TABLE
(
Name
NVARCHAR(10),
Cause NVARCHAR(10),
Score
INT
)
INSERT
@TestTable (
Name
, Cause, Score)
SELECT
N
'甲'
, N
'语文'
, 1
UNION
SELECT
N
'甲'
, N
'数学'
, 2
UNION
SELECT
N
'乙'
, N
'语文'
, 3
UNION
SELECT
N
'乙'
, N
'数学'
, 4
UNION
SELECT
N
'丙'
, N
'语文'
, 5
UNION
SELECT
N
'丙'
, N
'数学'
, 6
SELECT
*
FROM
@TestTable
ORDER
BY
Score
SELECT
Name
,语文,数学
FROM
(
SELECT
Name
, Cause, Score
FROM
@TestTable
) p
PIVOT
(
SUM
(Score)
FOR
Cause
IN
(语文,数学)
)
AS
pvt
ORDER
BY
pvt.语文;
|
lanse777
2014-03-18 00:48
评论
0
0