Boleh lht cnth queryny bro!


Dikirim melalui BlackBerrhyu® dari 3 – Jaringan GSM-Mu

-----Original Message-----
From: "Febry Kurniawan" <[email protected]>
Sender: [email protected]
Date: Mon, 17 May 2010 05:16:25 
To: <[email protected]>
Reply-To: [email protected]
Subject: Re: [indo-oracle] Help Me donk :(

Pake Sum trus di group by berdasarkan tanggal bos.

thx



Sent from my Blackberry



-----Original Message-----

From: Gugun <[email protected]>

Sender: [email protected]

Date: Mon, 17 May 2010 13:10:43 

To: <[email protected]>

Reply-To: [email protected]

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]



------------------------------------

--
-----------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





------------------------------------

--
-----------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/

Kirim email ke