Skip to content

Instantly share code, notes, and snippets.

@khaeransori

khaeransori/gist:8399227

Last active January 3, 2016 02:59
Show Gist options
  • Save khaeransori/8399227 to your computer and use it in GitHub Desktop.
Save khaeransori/8399227 to your computer and use it in GitHub Desktop.
Download ZIP
subquery
Raw
gistfile1.txt
SELECT
a.*,
(SELECT nama FROM penduduk WHERE nik=a.nik_kadus) as nama_kadus,
(SELECT COUNT(*) FROM rw WHERE id_dusun=a.id) as jumlah_rw,
(SELECT COUNT(*) FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) as jumlah_rt,
(SELECT COUNT(*) FROM kk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw = (SELECT id FROM rw WHERE id_dusun=a.id))) as jumlah_kk,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id))) as jumlah_jiwa,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) && jenis_kelamin='laki - laki') as jumlah_jiwa,
(SELECT COUNT(*) FROM penduduk WHERE id_rt IN (SELECT id FROM rt WHERE id_rw IN (SELECT id FROM rw WHERE id_dusun=a.id)) && jenis_kelamin='perempuan') as jumlah_jiwa
FROM dusun AS a
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment