这句话哪里不对呢？
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