JUMLAH TOTAL HAK PER KECAMATAN PER JENIS HAK

JUMLAH TOTAL HAK PER KECAMATAN PER JENIS HAK
---------------------------------------------------

select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
keca.kecanam KECAMATAN,
count(distinct htan.htanseq) JUMLAH_HAK
from htan,thak,keca,desa
where thak.thakcod=htan.thakcod
and desa.desaco8=htan.desaco8
and keca.kecacod=desa.kecacod
group by 1,2,3;

JUMLAH TOTAL HAK PER KECAMATAN PER JENIS HAK
TAPI SUDAH MATI
----------------------------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
keca.kecanam KECAMATAN,
count(distinct htan.htanseq) JUMLAH_HAK
from htan,thak,keca,desa
where thak.thakcod=htan.thakcod
and desa.desaco8=htan.desaco8
and keca.kecacod=desa.kecacod
and htan.htanflgact="N"
group by 1,2,3;


LIST HAK YANG TERBIT
----------------------------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
keca.kecanam KECAMATAN,
desa.desanam DESA,
htan.htanseq NO_HAK
from htan,thak,keca,desa
where thak.thakcod=htan.thakcod
and desa.desaco8=htan.desaco8
and keca.kecacod=desa.kecacod
order by 3,4;

LIST HAK YANG TERBIT TAPI SUDAH MATI
----------------------------------------------------
select htan.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
keca.kecanam KECAMATAN,
desa.desanam DESA,
htan.htanseq NO_HAK
from htan,thak,keca,desa
where thak.thakcod=htan.thakcod
and desa.desaco8=htan.desaco8
and keca.kecacod=desa.kecacod
and htan.htanflgact="N"
order by 3,4;

Baca Selengkapnya..

JUMLAH 301 PERJENIS KEGIATAN

select tind.tindcod,
tind.tinddes,
count(distinct d301.d301seq) JUMLAH_301
from tind,d301
where tind.tindcod=d301.tindcod
and year(d301.d301dat)=2006
group by 1,2;

-----------------------------------------------------
LIST 301 TAHUN 2006

select d301.d301seq NO_301,
d301.d301dat TGL_301,
d301.tindcod KODE_KEGIATAN,
tind.tinddes JENIS_KEGIATAN
from d301,tind
where tind.tindcod=d301.tindcod
and year(d301.d301dat)=2006;

Baca Selengkapnya..

SQL PETUGAS UKUR_ PEMOHON_SU_LUAS

TGL MULAI|TGL SELESAI|BERKAS|THN BERKAS|PEMOHON|KODE DESA|NAMA DESA|

LUAS|NO SU|THN SU|NIP|NAMA PETUGAS UKUR

SELECT puex.puexinidat TGL_MULAI,
puex.puexenddat TGL_SELESAI,
expe.expecod NO_BERKAS,
expe.expeyea THN_BERKAS,
shak.shaknam NAMA_PEMOHON,
puex.puexdsa KODE_DESA,
desa.desanam DESA,
puex.puexare LUAS,
inde.masterpk3 NO_SU,
inde.masterpk2 THN_SU,
puexsub.emplnip NIP,
empl.emplnam NAMA_PETUGAS_UKUR
FROM puexsub,puex,expe,empl,desa,shak,inde,suex
WHERE empl.emplnip=puexsub.emplnip
AND puexsub.expeid=puex.expeid
AND puexsub.opernum=puex.opernum
AND puexsub.expeid=expe.expeid
AND desa.desaco8=puex.puexdsa
AND expe.stexcod<>"CA"
AND suex.expeid=expe.expeid
AND suex.suexflgapp="Y"
AND inde.expeid=expe.expeid
AND inde.indetyp="S"
AND inde.tindcod<>"00"
AND shak.shakcod=suex.shakcod
AND year(puex.puexinidat)=2006;

SELECT puex.puexinidat TGL_MULAI,
puex.puexenddat TGL_SELESAI,
expe.expecod NO_BERKAS,
expe.expeyea THN_BERKAS,
shak.shaknam NAMA_PEMOHON,
puex.puexdsa KODE_DESA,
desa.desanam DESA,
puex.puexare LUAS,
inde.masterpk3 NO_SU,
inde.masterpk2 THN_SU,
puex.emplnip NIP,
empl.emplnam NAMA_PETUGAS_UKUR
FROM puex,expe,empl,desa,shak,inde,suex
WHERE month(puex.puexinidat)="02"
AND year(puex.puexinidat)=2006
AND empl.emplnip="010158685"
AND puex.emplnip="010158685"
AND puex.expeid=expe.expeid
AND desa.desaco8=puex.puexdsa
AND expe.stexcod<>"CA"
AND suex.expeid=expe.expeid
AND suex.suexflgapp="Y"
AND inde.expeid=expe.expeid
AND inde.indetyp="S"
AND inde.tdoccod in ("GS","SU")
AND shak.shakcod=suex.shakcod;

Baca Selengkapnya..

Error dengna keterangan Gambar denah tidak bisa dimasukan

select * from inde where indetyp="D" and tdoccod="GD"
and indelckexp is null

lalu hapus inde yang indelckexp ada isinya

Baca Selengkapnya..

BUKU TANAH PAKAI HPL HGU

DESA|JENIS HAK|NO HAK|NO SK|TGL SK|TGL BERAKHIR SK|NAMA PEMILIK|NOMOR SU|THN SU|LUAS

YG GS
-------------------------------------------------------------
select desa.desanum8 KODE_DESA,
htan.thakcod JENIS_HAK,
htan.htanseq NO_HAK,
decr.decrcodbpn NO_SK,
decr.decrisudat TGL_SK,
decr.decrexpdat TGL_AKHIR_SK,
shak.shaknam PEMILIK,
gsht.gssunum NOMOR_SU,
gsht.gssuyea TAHUN_SU,
gssuold.gssuare LUAS
from htan,decr,desa,inde,shak,shakinde,gsht,gssuold
where htan.thakcod in ("2","4","5")
and decr.decrcod=htan.decrcod
and desa.desaco8=htan.desaco8
and inde.masterpk1=htan.desaco8
and inde.masterpk2=htan.thakcod
and inde.masterpk3[1,8]=htan.htanseq
and inde.indetyp="R"
and shakinde.indecod=inde.indecod
and shak.shakcod=shakinde.shakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum;

DESA|JENIS HAK|NO HAK|NO SK|TGL SK|TGL BERAKHIR SK|NAMA PEMILIK|NOMOR SU|THN SU|LUAS
YG SU
-------------------------------------------------------------------
select desa.desanum8 KODE_DESA,
htan.thakcod JENIS_HAK,
htan.htanseq NO_HAK,
decr.decrcodbpn NO_SK,
decr.decrisudat TGL_SK,
decr.decrexpdat TGL_AKHIR_SK,
shak.shaknam PEMILIK,
paht.gssunum NOMOR_SU,
paht.gssuyea TAHUN_SU,
gssu.gssuare LUAS
from htan,decr,desa,inde,shak,shakinde,paht,gssu
where htan.thakcod in ("2","4","5")
and decr.decrcod=htan.decrcod
and desa.desaco8=htan.desaco8
and inde.masterpk1=htan.desaco8
and inde.masterpk2=htan.thakcod
and inde.masterpk3[1,8]=htan.htanseq
and inde.indetyp="R"
and shakinde.indecod=inde.indecod
and shak.shakcod=shakinde.shakcod
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum;

Baca Selengkapnya..

SQL JUMLAH TOTAL HAK PER TAHUN DAN PERBULAN

PERBULAN YG GS
------------------------------------------------------
select gsht.thakcod JENIS_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssuold.gssuare) JUMLAH_LUAS
from gsht,gssuold,htan,thak
where month(htan.htanboodat)="02"
and year(htan.htanboodat)=2006
and thak.thakcod=gsht.thakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
group by 1,2;

PERBULAN YG SU
--------------------------------------------------------
select paht.thakcod JENIS_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssu.gssuare) JUMLAH_LUAS
from paht,gssu,htan,thak
where month(htan.htanboodat)="02"
and thak.thakcod=paht.thakcod
and year(htan.htanboodat)=2006
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
group by 1,2;

PERTAHUN YG GS
--------------------------------------------------------
select gsht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssuold.gssuare) JUMLAH_LUAS
from gsht,gssuold,htan,thak
where year(htan.htanboodat)=2006
and thak.thakcod=gsht.thakcod
and gsht.desaco8=htan.desaco8
and gsht.thakcod=htan.thakcod
and gsht.htanseq=htan.htanseq
and gssuold.desaco8=gsht.desaco8
and gssuold.gssuyea=gsht.gssuyea
and gssuold.gssunum=gsht.gssunum
group by 1,2;

PERTAHUN YG SU
--------------------------------------------------------
select paht.thakcod KODE_HAK,
thak.thakdes JENIS_HAK,
count(*) JUMLAH_HAK,
sum(gssu.gssuare) JUMLAH_LUAS
from paht,gssu,htan,thak
where year(htan.htanboodat)=2006
and thak.thakcod=paht.thakcod
and paht.desaco8=htan.desaco8
and paht.thakcod=htan.thakcod
and paht.htanseq=htan.htanseq
and gssu.desaco8=paht.desaco8
and gssu.gssuyea=paht.gssuyea
and gssu.gssunum=paht.gssunum
group by 1,2;

Baca Selengkapnya..