select Registration_date, count(*)jumlah_pasien from tabel_visit
group by tanggal silahkan di coba bro.. --- Pada Sen, 17/5/10, izzudin.hanafie <[email protected]> menulis: Dari: izzudin.hanafie <[email protected]> Judul: Re: [indo-oracle] Help Me donk :( Kepada: [email protected] Tanggal: Senin, 17 Mei, 2010, 1:11 PM Mungking lebih tepat menggunakan COUNT... select tanggal, COUNT(*) as jumlah from tabel_visit group by tanggal CMIWW, Thanks IH --- On Mon, 5/17/10, atina dwi palupi <[email protected]> wrote: From: atina dwi palupi <[email protected]> Subject: Re: [indo-oracle] Help Me donk :( To: [email protected] Date: Monday, May 17, 2010, 1:21 AM itu per clinic yach...ada berapa klinik? aq coba jawab ya... niy querynya: select tanggal, SUM(jumlah_pasien) from tabel_visit group by tanggal coba dech...bisa gk? ________________________________ From: Gugun <[email protected]> To: [email protected] Sent: Mon, May 17, 2010 12:10:43 PM Subject: [indo-oracle] Help Me donk :( 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] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
