User Tools

Site Tools


kurs:fragen_dezember_2018

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

kurs/fragen_dezember_2018.1544998530.txt.gz · Last modified: 2018/12/16 23:15 by admin