Select
YEAR,
MONTH,
(Case When TYPE=0 And YEAR=2004 Then JE Else 0 End ) As 2004JE,
(Case When TYPE=1 And YEAR=2004 Then JE Else 0 End ) As 2004TKJE,
(Case When TYPE=0 And YEAR=2005 Then JE Else 0 End ) As 2005JE,
(Case When TYPE=1 And YEAR=2005 Then JE Else 0 End ) As 2005TKJE,
TYPE
from xs
Select
YEAR,
MONTH,
(Case When TYPE=1 And YEAR=2004 Then 0 Else JE End ) As 2004JE,
(Case When TYPE=1 And YEAR=2004 Then JE Else 0 End ) As 2004TKJE,
(Case When TYPE=1 And YEAR=2005 Then 0 Else JE End ) As 2005JE,
(Case When TYPE=1 And YEAR=2005 Then JE Else 0 End ) As 2005TKJE,
TYPE
from xs
2004JE=(case when YEAR=2004 and type=0 then je else 0 end),
2004TKJE=(case when YEAR=2004 and type=1 then je else 0 end),
2005JE=(case when YEAR=2005 and type=0 then je else 0 end),
2005TKJE=(case when YEAR=2005 and type=1 then je else 0 end),
TYPE
from 表
from xs
然后更改这个表
还有
可以参考
case.. when..end
语句解决这个问题