Select registration_date,count(1) jml_pasien form table_visit where trunc(registration_date) between '01-02-2010' and '01-05-2010' group by registration_date order by registration_date asc;
btw range tanggal nya kok tanggu ya, napa ngk ampe akhir bulan mei or akhir bulan april aja. 2010/5/17 Gugun <[email protected]> > > > Dear Para Master Oracle > > Berhubung saya masih Newbie,gimn yahh cara membuat query yang praktis > > dengan output seperti ini : > > Tanggal 1-feb-2010 = 3 Pasien > Tanggal 2-feb-2010 = 3 Pasien > Tanggal 3-feb-2010 = 3 Pasien > > karena user ingin mengetahui jumlah kunjungan perhari dari Periode 1 > februari 2010 s/d 1 Mei 2010 > > ---------------------------------------------------------- > > contoh Tabel seperti ini > > Tabel_visit > No. Registration_date Clinic > 1 1-feb-2010 Jantung > 2 > 1-feb-2010 Jantung > 3 1-feb-2010 Jantung > 4 2-feb-2010 Jantung > 5 2-feb-2010 Jantung > 6 2-feb-2010 Jantung > 7 3-feb-2010 Jantung > 8 3-feb-2010 Jantung > > 9 3-feb-2010 Jantung > > terima kasih Sebelumnya yahhh > > --Gugun--- > > > [Non-text portions of this message have been removed] > > > -- Warm regards, Rudy Wardhany Yahoo ID: [email protected] [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
