oracle row/column
LISTLAG
LISTAGG function Syntax
Aggregate Syntax: LISTAGG(measure_expr [, 'delimiter']) WITHIN GROUP (order_by_clause)
Analytic Syntax : LISTAGG(measure_expr [, 'delimiter']) WITHIN GROUP (order_by_clause)[OVER query_partition_clause]
For a specified measure, LISTAGG orders data within each group specified
in the ORDER BY clause and then concatenates the values of the measure column.
SELECT DEPARTMENT_ID, LISTAGG(FIRST_NAME, '|') WITHIN GROUP (ORDER BY FIRST_NAME) "Emp_list" FROM EMPLOYEESgroup by DEPARTMENT_ID
PIVOT
select * from (select department_id, job_idfromemployees
)
pivot
(count(1) for job_id in ('MK_MAN','MK_REP','PU_CLERK','PU_MAN')
)ORDER BY 1
select * from (select department_id,job_id, salaryfromemployees
)
pivot
(SUM(salary) for job_id in ('MK_MAN','MK_REP','PU_CLERK','PU_MAN')
)ORDER BY 1
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
