sori....group function memang harus menggunakan having.... thx mas Dede.... ----- Original Message ----- From: "Dede Supriyatna" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, October 09, 2005 11:39 PM Subject: [indo-oracle] Re: Bagaimana Menghitung Count?
> SELECT > NPP, > COUNT(IURAN) > FROM ADMIN.KU_IUR_PRS > WHERE KDNA IS NULL > AND SUBSTR(BLTH,8,2)='99' > GROUP BY NPP > HAVING COUNT(IURAN) < 12; > > --- In [email protected], "Addino Yudi Abdal" > <[EMAIL PROTECTED]> wrote: > > > > > > count merupakan group function jadi jika mau disatukan degan yg lain > gunakan > > grop by > > > > SELECT NPP, COUNT(IURAN) FROM ADMIN.KU_IUR_PRS WHERE KDNA IS NULL > > AND SUBSTR(BLTH,8,2)='99' AND COUNT(IURAN) < 12 > > GROUP BY NPP; > > > > ----- Original Message ----- > > From: "Norman Septiadi" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Friday, October 07, 2005 11:20 PM > > Subject: [indo-oracle] Bagaimana Menghitung Count? > > > > > > > Temen-temen saya minta bantuannya ya. > > > Begini, saya ingin menghitung perusahaan (diwakilkan dengan kode npp) > > > yang belum membayar iuran (iuran) di tahun 1999. > > > Asumsinya dalam 1 tahun di wakilkan dengan 12 x pembayaran (12 bulan). > > > JAdi jika suatu NPP (perusahaan) itu jumlah bulan bayarnya kurang dari > > > 12 maka dapat diasumsikan perusahaan tersebut belum membayar secara > > > penuh di tahun 1999. > > > > > > Tadinya saya menggunakan syntax seperti ini: > > > SQL> SELECT NPP, COUNT(IURAN) FROM ADMIN.KU_IUR_PRS WHERE KDNA IS NULL > > > AND SUBSTR(BLTH,8,2)='99' AND COUNT(IURAN) < 12; > > > > > > NPP = KODE PERUSAHAAN > > > IURAN = BULAN IURAN > > > KDNA = KODE PERUSAHAAN AKTIF ATAU TIDAK (AKTIF=NULL) > > > > > > Tapi Syntaxnya tidak berhasil. > > > Adakah teman-teman yang bisa membantu? > > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
