select cardid as \'账号\',tradeType=
case
when tradeType=1 then \'存款\'
when tradeType=2 then \'取款\'
end
,tradeMoney as \'交易金额\',tradeDate as \'交易日期\' from TradeInfo
go
与
select cardid as \'账号\',tradeType=
case
when tradeType=1 then \'存款\'
when tradeType=2 then \'取款\'
end
as \'交易类型\',tradeMoney as \'交易金额\',tradeDate as \'交易日期\' from TradeInfo
go
这两个语句
要将图中的tradeType转换成\'交易类型\'
|