Cari Data Kepemilikan Akta Kelahiran Dari Table DKB Semester


select rownum as "Nomor", a.* from 
(select
getnamaprop(no_prop) as "Nama Propinsi",
getnamakab(no_kab,no_prop) as "Nama Kabupaten",
getnamakec(no_kec,no_kab,no_prop) as "Nama Kecamatan",
sum(case when jenis_klmin =1 then 1 else 0 end) as "Laki2 Memiliki Akta" ,
sum(case when jenis_klmin =2 then 1 else 0 end) as "Perempuan Memiliki Akta",
sum(case when jenis_klmin in (1,2) then 1 else 0 end) as "Pddk Memiliki Akta" 
from biodata_wni_201801 where nik in (
select nik from biodata_wni_201801 where
nik in (select bayi_nik from capil_lahir)
union select nik from biodata_wni_201801 where
(akta_lhr= 2 and length (no_akta_lhr)>= 4))
group by rollup(no_kec),(no_kab, no_prop)
order by no_prop, no_kab, no_kec
) a;

Subscribe to receive free email updates:

1 Response to "Cari Data Kepemilikan Akta Kelahiran Dari Table DKB Semester"