bro da yg tau ga yah gmana caranya nampilin beberapa record dari query ini
pake query ini cuma 1 record yg keluar soalnya pakai parameter di query yg di pake jg di subquery.
Code:
select
cardfile.perusahaan,
min(pyr_gaji.bulan)AS AWALPERIODE,
max(pyr_gaji.bulan)AKHIRPERIODE,
sum(pyr_gaji.gajipokok)as gapok,
sum(pyr_gaji.tunjanganpph21/(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as tunjanganpph21,
sum(pyr_gaji.nilaipph21/(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as nilaipph21,
sum(pyr_gaji.nilaiptkp /(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as nilaiptkp,
(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=0) as nol
from pyr_gaji,cardfile
where
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and
cardfile.id=pyr_gaji.noindexcardfile
group by cardfile.perusahaan
parameter di subquery dan di luar subquery
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun |
