dokuwiki

This is an old revision of the document!

---

pivot dynamisch

WITH
   T
AS
(
   SELECT
      department_id,
      JOB_id,
      salary
   FROM
      employees
   where job_id in (
      'ST_CLERK', 'SH_CLERK'
   )
)
SELECT
   *
FROM
   T
PIVOT
(
   MIN(SALary) AS MINSAL,
   MAX(SALary) AS MAXSAL
FOR
   (JOB_ID)
   in
   (  'ST_CLERK', 'SH_CLERK')
)
ORDER BY
   department_id

select department_id, listagg(last_name, ', ') within group (order by job_id desc ) a from employees group by department_id;

sql scripts automatisch ausführen

zeitliche Nachverfolgung von Änderungen

zustand der session