Reply to comment

saya ada query sbb

saya ada query sbb :

select
a.KD_DATI2,
a.KD_KECAMATAN,
a.KD_KELURAHAN,
a.KD_BLOK,
a.TGL_PENDATAAN_OP as "Tanggal Pendataan",
count(a.TGL_PENDATAAN_OP) as "Jumlah Tanggal Pendataan"
from TABEL1 a
where
a.KD_DATI2='02' and
a.KD_KECAMATAN='080' and
a.KD_KELURAHAN='001'
group by
a.KD_DATI2,
a.KD_KECAMATAN,
a.KD_KELURAHAN,
a.KD_BLOK,
a.TGL_PENDATAAN_OP
order by
a.KD_DATI2,
a.KD_KECAMATAN,
a.KD_KELURAHAN,
a.KD_BLOK,
a.TGL_PENDATAAN_OP

yang saya tanyakan bagaimana query diatas dimodif supaya menghasilkan :

KD_DATI2,KD_KECAMATAN,KD_KELURAHAN,KD_BLOK,Tanggal Pendataan, Jumlah Tanggal Pendataan.

Adapun record yg dihasilkan adalah Tanggal Pendataan Paling Lama / paling awal pada tiap-tiap KD_BLOK.

Terima Kasih

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options