oracle行转列

SELECT *
FROM (SELECT t.parent_group,
t.country,
t.project_num
FROM RPT_GP_COUNTRY t
where t.parent_group is not null
and t.rpt_type = 0)
PIVOT (
SUM(project_num) --<-- pivot_clause
FOR parent_group --<-- pivot_for_clause
IN ('中电建','中石化') --<-- pivot_in_clause
)

转载于:https://blog.51cto.com/xqsea/1308148