Oracle SQL Pivot Örneği

				
					/* Formatted on 15/03/2022 13:59:44 (QP5 v5.227.12220.39724) */
SELECT *
  FROM (  SELECT b.islem,
                 SUM (a.ucreti) ucreti,
                 COUNT (CASE WHEN a.fatura_tipi = 0 THEN 1 ELSE NULL END) adet,
                 EXTRACT (MONTH FROM TO_DATE (a.tarih, 'dd.mm.yyyy')) AS Ay
            FROM hastane.islemyap a inner join hastane.islemtipi b on a.kodu=b.kodu 
           WHERE   
                  A.KODU IS NOT NULL
                 AND (   (b.grup_kodu BETWEEN 1 AND 29)
                      OR b.grup_kodu BETWEEN 50 AND 150)
                 AND a.tarih BETWEEN TO_DATE ('01.06.2021 00:00:00',
                                              'dd.mm.yyyy hh24:mi:ss')
                                 AND TO_DATE ('31.12.2021 23:59:59',
                                              'dd.mm.yyyy hh24:mi:ss')
        GROUP BY b.islem, a.tarih) PIVOT (SUM (ucreti) AS Ucreti,
                                         COUNT (adet) AS Adeti
                                   FOR ay
                                   IN  (1 AS Ocak_Ayi,
                                       2 AS Subat_Ayi,
                                       3 AS Mart_Ayi,
                                       4 AS Nisan_Ayi,
                                       5 AS Mayis_Ayi,
                                       6 AS Haziran_Ayi,
                                       7 AS Temmuz_Ayi,
                                       8 AS Agustos_Ayi,
                                       9 AS Eylül,
                                       10 AS Ekim_Ayi,
                                       11 AS Kasım_Ayi,
                                       12 AS Aralik_Ayi))