SQL UNION ALL (Ara Toplam Hesaplama)

  SELECT TCNO_VERGINO
      ,CARI_ACIKLAMA
      ,ULKESI
      ,AY
      ,ADET
      ,KDV_HARIC_TOPLAM
      ,BA_BS
   FROM WEB_BABS WHERE TCNO_VERGINO='2960415825' AND BA_BS='BA' 

   UNION ALL SELECT 'TOPLAM','','',NULL,NULL,SUM(KDV_HARIC_TOPLAM),'' 
   FROM WEB_BABS WHERE TCNO_VERGINO='2960415825' AND BA_BS='BA'  
   GROUP BY BA_BS ,TCNO_VERGINO ORDER BY TCNO_VERGINO,AY

Hiç yorum yok:

Yorum Gönder