PIVOT为行转列
语法
SELECT ....
FROM <table-expr>
PIVOT
(
aggregate-function(<column>)
FOR <pivot-column> IN (<value1>, <value2>,..., <valuen>)
) AS <alias>
WHERE .....
SELECT *
FROM (select fangkuanyue, mob, nvl(jine, '') jine
from tb_vintagemob
where type = '逾期额') T pivot(max(jine) FOR mob IN(