Blog Andri Wiratmono

Pagut Asri Blok D No.2 - Kelurahan Blabak - Pesantren Kota Kediri

back

Sintak Queri Menjumlah SKS di AKM Postgresql Database Feeder PDDIKTI

29 Desember 2017 || 15:00:03 WIB || ClassyID

Buat Catatan Saja

SELECT 
"public".reg_pd.nipd as npm,
"public".peserta_didik.nm_pd as nama_mhs,
sum("public".kuliah_mhs.sks_smt) as jumlah_sms,
"public".sms.nm_lemb as prodi,
"public".reg_pd.id_jns_daftar,
"public".reg_pd.id_jns_keluar,
"public".reg_pd.tgl_keluar,
"public".reg_pd.no_seri_ijazah,
"public".kuliah_mhs.id_reg_pd
FROM 
"public"."kuliah_mhs",
"public".reg_pd,
"public".peserta_didik,
"public".sms
WHERE
"public".kuliah_mhs.id_reg_pd="public".reg_pd.id_reg_pd AND
"public".reg_pd.id_pd="public".peserta_didik.id_pd AND
"public".reg_pd.id_sms="public".sms.id_sms
GROUP BY 
"public".kuliah_mhs.id_reg_pd,
"public".reg_pd.id_reg_pd,
"public".peserta_didik.id_pd,
"public".sms.id_sms
;