Jumlah BT Aktif

Jumlah BT Aktif yang belum di entry
==========================
select count(*),htan.thakcod,thak.thakdes,htan.desaco8,desa.desanam
from htan,desa,thak
where htanflgact<>"N"
and htan.emplnip is null
and htan.htanflgan is null
and desa.desaco8=htan.desaco8
and htan.thakcod=thak.thakcod
group by htan.thakcod,htan.desaco8,desa.desanam,thak.thakdes;

Jumlah BT yang sudah di entry
==========================
select count(*),htan.thakcod,thak.thakdes,htan.desaco8,desa.desanam
from htan,desa,thak
where htanflgact<>"N"
and htan.emplnip is not null
and htan.htanflgan is not null
and desa.desaco8=htan.desaco8
and htan.thakcod=thak.thakcod
group by htan.thakcod,htan.desaco8,desa.desanam,thak.thakdes;



1) JUMLAH BUKU TANAH
-------------------------------------------
select desaco8,
thakcod,
count(distinct htanseq) Jumlah_Hak
from htan
group by desaco8,thakcod;

2) JUMLAH SU
-------------------------------------------
select desaco8,
count(distinct gssunum) Jumlah_SU
from gssu
group by desaco8;

3) JUMLAH GS
-------------------------------------------
select desaco8,
count(distinct gssunum) Jumlah_GS
from gssuold
group by desaco8;

4) JUMLAH NIB
-------------------------------------------
select desaco8,
count(distinct parcnib) Jumlah_NIB
from gspa
group by desaco8;

-------------------------------------------
KETERANGAN :
JUMLAH SU TEKSTUAL HASIL PENJUMLAHAN SQL 2 DAN 3.
JUMLAH SU SPATIAL SQL NO. 4