这句话哪里不对呢?
select ContractNm,RepayType,receivableAmount
from InterestReceive pivot
(sum(receivableAmount)
for RepayType in(OnceCharge,OtherCharge))
请大家帮忙看看
[解决办法]
select ContractNm,OnceCharge,OtherCharge from InterestReceive pivot (sum(receivableAmount) for RepayType in(OnceCharge,OtherCharge)) pvt