1 回答

TA貢獻(xiàn)1810條經(jīng)驗(yàn) 獲得超4個(gè)贊
由于要轉(zhuǎn)動(dòng)多列數(shù)據(jù),我會(huì)首先建議unpivoting的result,score并且grade列,所以你不必多列,但你將有多個(gè)行。
根據(jù)您的SQL Server版本,您可以使用UNPIVOT函數(shù)或CROSS APPLY。取消數(shù)據(jù)透視的語(yǔ)法類(lèi)似于:
select ratio, col, value
from GRAND_TOTALS
cross apply
(
select 'result', cast(result as varchar(10)) union all
select 'score', cast(score as varchar(10)) union all
select 'grade', grade
) c(col, value)
請(qǐng)參閱帶有演示的SQL Fiddle。一旦數(shù)據(jù)被取消透視,就可以應(yīng)用PIVOT功能:
select ratio = col,
[current ratio], [gearing ratio], [performance ratio], total
from
(
select ratio, col, value
from GRAND_TOTALS
cross apply
(
select 'result', cast(result as varchar(10)) union all
select 'score', cast(score as varchar(10)) union all
select 'grade', grade
) c(col, value)
) d
pivot
(
max(value)
for ratio in ([current ratio], [gearing ratio], [performance ratio], total)
) piv;
請(qǐng)參閱帶有演示的SQL Fiddle。這將為您提供結(jié)果:
| RATIO | CURRENT RATIO | GEARING RATIO | PERFORMANCE RATIO | TOTAL |
|--------|---------------|---------------|-------------------|-----------|
| grade | Good | Good | Satisfactory | Good |
| result | 1.29400 | 0.33840 | 0.04270 | (null) |
| score | 60.00000 | 70.00000 | 50.00000 | 180.00000 |
- 1 回答
- 0 關(guān)注
- 676 瀏覽
添加回答
舉報(bào)