这句话哪里不对呢？
select ContractNm,RepayType,receivableAmount
from InterestReceive pivot
(sum(receivableAmount)
for RepayType in(OnceCharge,OtherCharge))

请大家帮忙看看

[解决办法]

SQL code

select ContractNm,OnceCharge,OtherCharge from InterestReceive pivot   (sum(receivableAmount)  for RepayType in(OnceCharge,OtherCharge)) pvt